Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
On Jun 13, 6:35*am, Freshman
wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |