Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Lookup match 2 items
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% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup nearest value (Index & Match) | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Match function multiple items | Excel Worksheet Functions | |||
Lookup across 2 or more columns to match a row | Excel Worksheet Functions | |||
Lookup Match | Excel Worksheet Functions |