I have a spreadsheet with Pipe Dia in one columnn a1 and pipe thickness b2
in another column. In a another sheet i have a pricing table
Pipe Thickness
Pipe Dia 3 4 6 7.5 9
4 $1 $2. $3 $4 $ 5
6 $3 $4 $5 $ 5 # 6
8 3.5 4.5 5.5 6.5 7
I would like to write index or lookup function that will return the
following. If pipe diameter in a1 =8 and pipe diamter b2 =6 it will
return $5.5