There'll be a clever way, but for me

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

Steve

On Wed, 16 Aug 2006 16:18:01 +0100, HFC-SC
wrote:

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%