View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

One way

=INDEX($C$1:$C$13,MATCH(1,($A$1:$A$13=$F$1)*($B$1: $B$13=$G$1),0))

entered with ctrl + shift & enter



--
Regards,

Peo Sjoblom


"Columbo" wrote in message
...
I have a price list in excel that I print and give to my salesmen, right
now
they just look on the chart to get the prices. A2 thru A13 show the
height,
B1 thru T1 show the width and B2 thru T13 show the prices. I'd like to use
excel to enter a width in one cell and height in another to get the price
and
think I have to use < for the measurments in between. I have played
around
with this off & on and have realized I have no idea where to start. If you
have any ideas, please let me know.