| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two lists and return specified data
I need to be able to compare two lists and return values from one to the other.
For example if 'Ben' from My list is found in the Reference list, then autofill/return/extract/copy the value 'FL' into My list. My list Column A Column B Name Ben Reference list: Column A Column B Name State Ben FL I'ave used the MATCH and VLOOKUP functions, but its not quite getting the job done. Please help! -- Clement E |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing two lists and return specified data
Clement,
In cell BXXX of My List: =VLOOKUP(AXXX,ReferenceListAddressAbsolute,2,False ) For example: =VLOOKUP(A2,'Sheet 2'!$A$1:$B$25,2,FALSE) HTH, Bernie MS Excel MVP "Clement" wrote in message ... I need to be able to compare two lists and return values from one to the other. For example if 'Ben' from My list is found in the Reference list, then autofill/return/extract/copy the value 'FL' into My list. My list Column A Column B Name Ben Reference list: Column A Column B Name State Ben FL I'ave used the MATCH and VLOOKUP functions, but its not quite getting the job done. Please help! -- Clement E |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing two lists and return specified data
THANK YOU Bernie!!
Worked like a charm!!! -- Clement E "Bernie Deitrick" wrote: Clement, In cell BXXX of My List: =VLOOKUP(AXXX,ReferenceListAddressAbsolute,2,False ) For example: =VLOOKUP(A2,'Sheet 2'!$A$1:$B$25,2,FALSE) HTH, Bernie MS Excel MVP "Clement" wrote in message ... I need to be able to compare two lists and return values from one to the other. For example if 'Ben' from My list is found in the Reference list, then autofill/return/extract/copy the value 'FL' into My list. My list Column A Column B Name Ben Reference list: Column A Column B Name State Ben FL I'ave used the MATCH and VLOOKUP functions, but its not quite getting the job done. Please help! -- Clement E |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Lists | Excel Worksheet Functions | |||
| look up one value and return a corresponding value using lists | Excel Worksheet Functions | |||
| have a cell return one of severl lists based on data from another | Excel Discussion (Misc queries) | |||
| Match two lists and return a value | Excel Worksheet Functions | |||
| How do I return dynamic lists? | Excel Worksheet Functions | |||
Linear Mode
