Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching two sets of data?
Hi,
I have two sets of data, one in A1:A450 and the other in D1:D700. I want the matching data (reference) of the array in column A to appear in Column C or next to the matched value of column D. Example: A B C D 23 14 12 52 37 89 45 23 23 Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching two sets of data?
In E1: =IF(ISNA(MATCH(D1,A:A,0)),"","A"&MATCH(D1,A:A,0))
Copy down to return col A's cell references where col A match col D. Eg you will get "A1" returned in E4 for your sample data. Any good? hit the YES below -- Max Singapore --- "Zuo" wrote: I have two sets of data, one in A1:A450 and the other in D1:D700. I want the matching data (reference) of the array in column A to appear in Column C or next to the matched value of column D. Example: A B C D 23 14 12 52 37 89 45 23 23 Thanks in advance for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching two sets of data?
Max,
Almost there but I want the actual matching reference that is sitting in A1 to appear in E4 next to its match on D4. Not the cell location but the actual data. i.e. if A1=23 and D4 =23 then 23 should appear in E4 or next to D4. Thanks. "Max" wrote: In E1: =IF(ISNA(MATCH(D1,A:A,0)),"","A"&MATCH(D1,A:A,0)) Copy down to return col A's cell references where col A match col D. Eg you will get "A1" returned in E4 for your sample data. Any good? hit the YES below -- Max Singapore --- "Zuo" wrote: I have two sets of data, one in A1:A450 and the other in D1:D700. I want the matching data (reference) of the array in column A to appear in Column C or next to the matched value of column D. Example: A B C D 23 14 12 52 37 89 45 23 23 Thanks in advance for your help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching two sets of data?
Max,
Any thoughts on how to address my comment below? Regards, ZUO "Zuo" wrote: Max, Almost there but I want the actual matching reference that is sitting in A1 to appear in E4 next to its match on D4. Not the cell location but the actual data. i.e. if A1=23 and D4 =23 then 23 should appear in E4 or next to D4. Thanks. "Max" wrote: In E1: =IF(ISNA(MATCH(D1,A:A,0)),"","A"&MATCH(D1,A:A,0)) Copy down to return col A's cell references where col A match col D. Eg you will get "A1" returned in E4 for your sample data. Any good? hit the YES below -- Max Singapore --- "Zuo" wrote: I have two sets of data, one in A1:A450 and the other in D1:D700. I want the matching data (reference) of the array in column A to appear in Column C or next to the matched value of column D. Example: A B C D 23 14 12 52 37 89 45 23 23 Thanks in advance for your help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching two sets of data?
... Not the cell location but the actual data ..
It's even simpler then .. In E1, copied down: =IF(ISNA(MATCH(D1,A:A,0)),"",D1) Success? hit the YES below -- Max Singapore --- "Zuo" wrote: Almost there but I want the actual matching reference that is sitting in A1 to appear in E4 next to its match on D4. Not the cell location but the actual data. i.e. if A1=23 and D4 =23 then 23 should appear in E4 or next to D4. Thanks. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching two sets of data?
Perfect! Thanks a lot Max.
"Max" wrote: ... Not the cell location but the actual data .. It's even simpler then .. In E1, copied down: =IF(ISNA(MATCH(D1,A:A,0)),"",D1) Success? hit the YES below -- Max Singapore --- "Zuo" wrote: Almost there but I want the actual matching reference that is sitting in A1 to appear in E4 next to its match on D4. Not the cell location but the actual data. i.e. if A1=23 and D4 =23 then 23 should appear in E4 or next to D4. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find %ontime & SUMIF ontime ie: find matching sets within Range... | Excel Worksheet Functions | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
Matching two different data sets | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |