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

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 <[email protected]>,
"Adnan" <[email protected]> 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

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" <[email protected]> wrote in message
news:[email protected]...
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 <[email protected]>,
"Adnan" <[email protected]> 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