thanks for your help so far. i have changed headers to suit. but the i think
the link shows me for a "match". What command do i use so it keeps going down
the row until it finds a number no bigger than the door width and then
accross the columns to find a number no bigger than the width?

"T. Valko" wrote:

Make it like this:

http://img388.imageshack.us/img388/1471/lookup2cx1.jpg

Biff

"Joe Black" wrote in message
...
101 - 150 151 - 250 251 - 300 301 - 350
125 - 230 $18.32 $19.97 $20.05 $20.56
231 - 350 $20.90 $23.29 $23.61 $24.63
351 - 450 $22.85 $25.86 $27.56 $29.35
451 - 550 $24.55 $28.27 $32.47 $34.56
551 - 650 $24.80 $30.61 $34.91 $36.95
651 - 800 $24.88 $33.83 $37.04 $38.87
801 - 950 $27.29 $37.05 $41.58 $43.43

this is how the matrix looks

"T. Valko" wrote:

You need to restructure your table.

Make it so that both the vertical and the horizontal headers are the
lower
boundary of each size interval.

See this screencap:

http://img252.imageshack.us/img252/6260/lookupny4.jpg

Biff

"Joe Black" wrote in message
...
Hello, i want to lookup a certain price of a door in a price matrix
that
matches criteria both in the left most column and topmost row that is
between
2 values (for height) and 2 values (for width). So eg. i want to find
the
price of a door which is 720 high X 450 Wide. I have to retrieve the
price
from the matrix that the door sits in. So for left most column it maybe
between sizes 650-830High and 380-490wide, where 650-830 sits in one
cell.
Any help appreciated. if i haven't explained myself properly or you
need
further information please ask.

cheers