A
Annette
I have a cell, with a lookup table that I can't get the formula correct and
maybe I'm not even using the correct formula.
Table contains:
cell A B C
bx 4 gal
pail 10 lbs
bag 25 kg
ton 2000 ton
I want to match the "ORDER FORM" cell c to look at the table (ALPHA
PRODUCTS) and match the corresponding cell in A (above from Alpha Products),
then display cell b (Alpha PRoducts) as the answer in ORDER FORM cell c.
What do I need to use!
Thanks, Annette
maybe I'm not even using the correct formula.
Table contains:
cell A B C
bx 4 gal
pail 10 lbs
bag 25 kg
ton 2000 ton
I want to match the "ORDER FORM" cell c to look at the table (ALPHA
PRODUCTS) and match the corresponding cell in A (above from Alpha Products),
then display cell b (Alpha PRoducts) as the answer in ORDER FORM cell c.
What do I need to use!
Thanks, Annette