Forum Discussion
TRUE vlookup brings the wrong results
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!
Found the solution!!! To be honest, my sister did! Teamwork is great!
This formula fixed the issue.
=VLOOKUP(A2&" *",costing!$A:$B,2,FALSE)
Hope this helps others at the Microsoft board.
THANK YOU! I was using VLOOKUP to locate matching company names between sheets, but some of the names would include "Inc." etc. as the data was pulled from different sources. My first attempt only pulled exact matches, but adding the &"*" added the different versions of the company names. You are a life saver!
Thank you saved my data analysis!!! Was about to give up...but didn't
Updating by taking out the space before the *.
=VLOOKUP(A2&"*",costing!$A:$B,2,FALSE)
Let me know if this helps with your VLOOKUP.
thank you for this but am lost @costing. FALSE vlookup is giving me wrong results even though the values are there on the table.
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?
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!
