VLOOKUP and Large returning Correct value but wrong Description
I have the VLOOKUP set up but it’s returning the wrong result. For example:
According to the Large function, 6,990 is the amount that we’ve spent the 5th most on so far this year, when I scroll through and find that total, it’s the Sidelaster Conversion that show's we've spent 6,990, however it comes back as the BDF Boxtoe Press which we’ve only spent 18 dollars on. It works for some but not for others…
Not sure why it would do that if the formula parameters are all the same…. I have some screenshots below.
Formula:
Summary of total:
The first three items correspond correctly, with the 12,260 matching what is in my field data.
Actual total:
Best Answer
-
Try specifying an exact match by including the false argument in the final portion of the VLOOKUP.
Answers
-
Try specifying an exact match by including the false argument in the final portion of the VLOOKUP.
-
That worked Paul. Thanks again!😁
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!