View Single Post
  #3   Report Post  
steve
 
Posts: n/a
Default

mangesh thanks but
i have varying heights and widths from 2000 to 3200 in height and width
range 2200 to 5400. my prices are in a table format of 200mm increments with
a price in the cross over range of each height and width.
does the formula you kindly sent work like this using the two paraimeter of
height and width which can both alter ?

"Mangesh" wrote:

A B C D E
1 1 2 3 4
2 1 a b c d
3 2 e f g h
4 3 i j k l
5 4 m n o p

Use:
=VLOOKUP(A4,A2:E5,MATCH(C1,B1:E1,0)+1)
to get j

Mangesh



"steve goundry" <steve wrote in message
...
i want to reference a table type price list, using height and width, 2
sources. How do i do it???