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

Marcelle Conradie
Marcelle Conradie โœญโœญโœญ

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)

image.png

Range:

image.png


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!