VLOOKUP and Large returning Correct value but wrong Description

Walter Mootz

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:

Paul Newcome

Try specifying an exact match by including the false argument in the final portion of the VLOOKUP.

Paul Newcome

Try specifying an exact match by including the false argument in the final portion of the VLOOKUP.

Walter Mootz

https://community.smartsheet.com/discussion/comment/272985#Comment_272985

That worked Paul. Thanks again!😁

Paul Newcome

Happy to help. 👍️