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
|