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!😁
Help Article Resources
Categories
Check out the Formula Handbook template!