Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOK
Hi,
while using Excel i came across with the problem of comparisions. In Sheet 1 i have three Columns (A, B & C ) and on Sheet 2 i have two columns A& B. I need to match sheet 1 column A & B with Column Sheet 2 A & B if both matched then Sheet 1 Column C text will be placed in sheet 2 column c .. regards |
#2
|
|||
|
|||
Try...
Sheet2!C1, copied down: =INDEX(Sheet1!$C$1:$C$100,MATCH(1,(Sheet1!$A$1:$A$ 100=Sheet2!A1)*(Sheet1! $B$1:$B$100=Sheet2!B1),0)) ....confirmed with CONTRO+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Adnan" wrote: Hi, while using Excel i came across with the problem of comparisions. In Sheet 1 i have three Columns (A, B & C ) and on Sheet 2 i have two columns A& B. I need to match sheet 1 column A & B with Column Sheet 2 A & B if both matched then Sheet 1 Column C text will be placed in sheet 2 column c . regards |
#3
|
|||
|
|||
Domenic's suggestion works with text and/or numbers being returned from
Column C. However, if Column C *only* contains numbers, you have this non-array option: =SUMPRODUCT((Sheet1!$A$1:$A$20=A1)*(Sheet1!$B$1:$B $20=B1)*Sheet1!$C$1:$C$20) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Domenic" wrote in message ... Try... Sheet2!C1, copied down: =INDEX(Sheet1!$C$1:$C$100,MATCH(1,(Sheet1!$A$1:$A$ 100=Sheet2!A1)*(Sheet1! $B$1:$B$100=Sheet2!B1),0)) ....confirmed with CONTRO+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Adnan" wrote: Hi, while using Excel i came across with the problem of comparisions. In Sheet 1 i have three Columns (A, B & C ) and on Sheet 2 i have two columns A& B. I need to match sheet 1 column A & B with Column Sheet 2 A & B if both matched then Sheet 1 Column C text will be placed in sheet 2 column c . regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlook up and if formula | Excel Worksheet Functions | |||
Vlook up for matching data in two seperate sheets | Excel Discussion (Misc queries) | |||
Vlook up or index match | Excel Worksheet Functions | |||
How do I use drop down list selections/values in a vlook up formu. | Excel Discussion (Misc queries) | |||
"Vlook up + IF" | Excel Worksheet Functions |