Partial Match Query - VLookup not giving accurate results for some obvious matches.
I want to pull the Account Owner data in one table to the same field in another table with a formula that identifies a close match in the Account Name cells. Both tables have a list of Account Names. I’ve tried the following but neither seem to pick up some obvious matches.
=VLOOKUP(CONCATENATE("*",A2,"*"),'SF Data'!$A$1:$Q$4625,2,FALSE)
=VLOOKUP(CONCATENATE("*"&LEFT(A2,5)&"*"),'SF Data'!A1:Q4625,2,FALSE)
Are the account names in column A numbers? or text?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi, they're formatted as text. Do they need to be in number format?
no, the result of "*"&LEFT(A2,5)&"*" is text, so the items in column A should also be text.
What is a typical result of "*"&LEFT(A2,5)&"*" and a typical value to match it with in column A on other sheet?
Can you supply a sample workbook showing how it's not getting the correct results?
Can't seem to attach anything - any tips on doing that first?
Remove unnecessary sheets or data that may make the workbook to large (or try zipping it first).. or put it in Dropbox and post a link.
Thanks, I've just had a colleage give me some guidance so will try that first and then come back to you if I'm still at a loss. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks