V look up for jumbled words in excel

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

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 •

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.


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