VLOOKUP returning wrong value - solved
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.
Comments
-
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.
-
Great, you just saved my brain from overheating ;-)
Projektmanagement Professional in Frankfurt am Main, Germany
-
This was extremely helpful for me today. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!