i want to reference a table type price list, using height and width, 2
sources. How do i do it???

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???

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???

Hi Steve,

the formula would work as long as you don't expect it to interpolate. Just
give the proper ranges and let me know if you are getting expected results.

Mangesh


"steve" wrote in message
...
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???