Lookup price formula
I have a work sheet with prices on it. Across the top are widths down the
side is length.
24 30 36 ............................120
24 $1.00 $2.00 $3.33
30 2.20 3.20 4.20
..
..
120
On another work sheet i have a width and length cells when i enter sizes i
want it to return price. EG width might be 26 and length maybe 27 i want to
return price of 3.20. does anyone know how to do this. i new to excel so keep
it simply please if possible
|