Try this array-entered** formula...

=INDEX(Sheet2!C1:C10,MATCH(1,(Sheet1!A1=Sheet2!A1: A10)*(Sheet1!D1=Sheet2!B1:B10),0))

** Commit the formula by pressing Ctrl+Shift+Enter, not just Enter.

Rick


"bkunes" wrote in message
...

I want to search sheet 2 for both column a and d in sheet 1, and return
column c of sheet 2

sheet 1
a b c d
KD083 12 1 SC513-0001-67.81

sheet 2
a b c
KD082 SCV219-0001-72 4
KD082 SC092/093HB 1
KD082 IT1414/1714 1
KD082 SC513-0001-67.81 1
KD082 DT1414/1714 1
KD082 SCV220-0001-48 4
KD083 SC513-0001-67.81 1
KD083 T-790-68 1
KD083 IT1415/1715 1
KD083 SC092/093HB 1
KD083 SC511-0001-67.81 1


--