=INDEX(Sheet2!C1:C100,MATCH(1,(Sheet2!A1:a100=A1)* (Sheet2!B1:B100=B1),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"HFC-SC" wrote in message
...
I want to lookup 2 items for a match to enter 3rd item.

EPP 2.80 x? want A3 to have a lookup function
that matches both A1 and A2 to the array.


EPS 1.25 0.5%
EPS 1.5 0.5%
EPS 1.75 0.5%
EPS 2 0.5%
EPS 2.25 0.5%
EPS 2.5 0.5%
EPS 3 0.5%
Gcet 3 0.5%
Gcet 5 0.5%
Rmer 1.5 0.5%
Rmer 1.75 0.5%
Rmer 2 0.5%
Rmer 2.25 0.5%
Rmer 2.5 0.5%
Rmer 3 0.5%
Arcel 1.5 1.0%
EPP-B 3.75 2.2%
EPP-W 3.75 2.2%
EPP-B 2.8 2.3%
EPP-W 2.8 2.3%
EPP-B 1.88 2.5%
EPP-W 1.88 2.5%
EPE 2 3.0%
EPE 3 3.0%
EPP-B 1.3 3.0%
EPP-W 1.3 3.0%