Forum Discussion
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...
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!