VLOOK

[Guest]

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

 

[Domenic]

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!

 

[RagDyeR]

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!
==============================================



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!