Forum Discussion
Sotiris Moschou
Dec 14, 2017Copper Contributor
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...
Sotiris Moschou
Jan 05, 2019Copper Contributor
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
Jan 06, 2019Copper Contributor
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!