HOW DO I LOOK UP AVALUE IN A TABLE WITH USING 2 DATA SOURCES

[steve goundry]

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

 

[Mangesh]

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]

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 Yadav]

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