V look up for jumbled words in excel

November 23, 2010 at 10:27:47
Specs: Windows Vista
Hi,

I am trying to compare two sheets of employee details one sheets emp name is in (FirstName-Middle-LastName) format and other one is (LastName-Middle-FirstName) format. I want to return the emp id, As I don't have emp ID in one sheet. How to use VLook up function for this.




See More: V look up for jumbled words in excel

Report •

#1
November 23, 2010 at 12:10:48
There is no VLOOKUP syntax that is going to be able to find a non-matching text value such as you described.

I suggest that you check out this page and see if you can add a column in which you have "rearranged" the names such that they match on both sheets.

http://www.cpearson.com/excel/First...

Based on my personal experiences, you should be able to "fix" the majority of your names and with a little bit of manual work, end up with exact matches across both sheets.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question