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.


Summary of total:

The first three items correspond correctly, with the 12,260 matching what is in my field data.

Actual total:

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!