Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two lists and extracting data from one to another
I need to be able to compare two lists and then move data from one to the
other if records are matched. For example, I need to fill in Ben's State in My List but only if there is a match in the Reference List. My List: Column A Column B Name State Ben Reference List: Column A Column B Name State Ben FL I used the MATCH and VLOOKUP functions but has not quite got the job done Please help! -- Clement E |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two lists and extracting data from one to another
maybe
=if(isna(vlookup(A2,StateRange,2,1),"",vlookup(A2, StateRange,2,1)) "Clement" wrote: I need to be able to compare two lists and then move data from one to the other if records are matched. For example, I need to fill in Ben's State in My List but only if there is a match in the Reference List. My List: Column A Column B Name State Ben Reference List: Column A Column B Name State Ben FL I used the MATCH and VLOOKUP functions but has not quite got the job done Please help! -- Clement E |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two lists and extracting data from one to another
It was worth a try even though it did not work. I did however get the correct
function from a previous post I made which I thought did not go through. Its under the same heading title. Thanks for the response though... -- Clement E "Duke Carey" wrote: maybe =if(isna(vlookup(A2,StateRange,2,1),"",vlookup(A2, StateRange,2,1)) "Clement" wrote: I need to be able to compare two lists and then move data from one to the other if records are matched. For example, I need to fill in Ben's State in My List but only if there is a match in the Reference List. My List: Column A Column B Name State Ben Reference List: Column A Column B Name State Ben FL I used the MATCH and VLOOKUP functions but has not quite got the job done Please help! -- Clement E |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Entries in two lists | Excel Worksheet Functions | |||
Extracting data | Excel Discussion (Misc queries) |