| 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. |
| 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 | |||
Threaded Mode
