Vlookup #no match error only on one element in range...

Options

I am wrecking my brains trying to figure out why my vlookup returns #NO MATCH result for one of my selection options, but all other options are working? What am I missing...can someone please put me out of my misery... πŸ˜‚


I have checked spelling, spaces....it will probably be something stupid..but I am stumped...


=VLOOKUP(Complexity@row, Complexity$2:Data$5, 2)

Range:


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!