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
Bookmarks