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


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)



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!