VLOOKUP

[Freshman]

Dear experts,

I have a file containing staff information. Column A is for names and B for
extension numbers. For an example:

Lee Chi Ho, Peter x21754

Yesterday, I received an external file which I need to work on. However, the
staff names in this file are input in a different way.

Peter Lee

As I want to use VLOOKUP in colum B of the external file, can it returns the
extension number 21754 based on Peter Lee vs Lee Chi Ho, Peter in the
original file? Can it be done or are there any other ways to return the
results?

Please kindly advise.

Thanks in advance.

 

[Nayab]

Dear experts,

I have a file containing staff information. Column A is for names and B for
extension numbers. For an example:

Lee Chi Ho, Peter             x21754

Yesterday, I received an external file which I need to work on. However, the
staff names in this file are input in a different way.

Peter Lee

As I want to use VLOOKUP in colum B of the external file, can it returns the
extension number 21754 based on Peter Lee vs Lee Chi Ho, Peter in the
original file? Can it be done or are there any other ways to return the
results?

Please kindly advise.

Thanks in advance.

Well, My 2 cents :

In both the sheets, try to extract the first name, middle name and
last name in different columns and then do a combination of if and
vlookup. I think it will solve the issue at hand