Lookup match 2 items

[Guest]

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%

 

[SteveW]

There'll be a clever way, but for me

I'd add a helper column =A1&A2 then lookup on EPP2.80

Steve

 

[Bob Phillips]

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

 

[Guest]

SteveW thanks this works for me

There'll be a clever way, but for me

I'd add a helper column =A1&A2 then lookup on EPP2.80

Steve

 

[Guest]

is there always a match?
Is it always a Unique answer in each case?
Assume the match is further down in the table than your example permits

=SUMPRODUCT(--(C1:C100=A1),--(D1100=A2),E1:E100)