Forum Discussion

Copper Contributor

Dec 14, 2017

TRUE vlookup brings the wrong results

Hello to all, I wanted to make my full-of-vlookups workbook faster so I thought I would start using vlookups(TRUE) on a sorted table since I read that its faster that way. Problem is that...

excel

Formulas and Functions

vlookup

JoB_19

Copper Contributor

Jan 05, 2019

Having the very same issue using TRUE I have used FALSE to get an "exact" match for each row, but the results are #NA. I think this might be a formatting issue for the data sheet. Or maybe the problem with the Page ID number.

=VLOOKUP(A2,costing!$A$2:$B$3000, 2, FALSE)

Appreciate any help!

Sotiris Moschou

Copper Contributor

Jan 05, 2019

Thanks for the reply,

I was starting to believe that I'm the only one having that issue :)

One year later and I still haven't found a solution to this.. I also thought about the 'formatting issue' you mentioned but I'm not sure what you mean about the page id number.. what is that id and how it can affect vlookup?

JoB_19
Copper Contributor
Jan 06, 2019
You are having the same issue that many people are experiencing. The answer should be simple, but it is NOT. I have a few people looking at this issue and we hope to discover a solution!

I only mentioned the page id because Microsoft Excel VLOOKUP Refersher mentions getting the name correct; which of course I have done. Agree the name ID is not the problem! I was just looking for a solution.

Hopefully someone with reply and tell us the issue with our VLOOKUP formula!