Home/ Questions/Q 5064
Next
In Process
Computing Staff
  • 1
Asked: 2021-11-12T10:13:37+00:00 In:

V Look Up For Jumbled Words In Excel

  • 1

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.

Share

    1 Answer

    1. 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.

      • 0