VLOOKUP returning wrong value - solved

jk

I had the following post ready to go, but figured out the problem. I'll still post to help anyone else.

Essentially, when the VLOOKUP final parameter is left to default (true), Smartsheet thinks that "Low" is close enough to "High" to return the value for "High".

When I change the final parameter to false, it returns the correct value. The original issue is below:

I have a very simple table - two columns A, B each with three values. column A contains my lookup values (High, Medium, Low) and B contains the return value (5, 3, 1).  I did this with both drop down symbols and a text column for column A.

This is what is happening: 

When A1 is the lookup value it return the correct value (B1)

When A2 is the lookup value it returns the correct value (B2)

When A3 is the lookup value is returns B1, not B3.

Shaine Greenwood

Thanks for posting this!

I linked someone else to this post as an example for using the false parameter in VLOOKUP to get better results.

Stefan 7k

Great, you just saved my brain from overheating ;-)

 

Katrina

This was extremely helpful for me today. Thank you!