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

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

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

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

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

sorry i thought id better post this. i hope this explains it a bit better. i
need the top matrix to be filled out by looking at the bottom matrix
according to sizes(topmost leftmost column/row).

240 301
240 $- $- $-
301 $- $- $-
421 $- $- $-
541 $- $- $-
661 $- $- $-

251 301 351
351 $15.00 $20.05 $20.56
451 $20.00 $23.61 $24.63
551 $21.00 $27.56 $29.35
651 $25.00 $32.47 $34.56
801 $30.00 $34.91 $36.95


"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

I'm not following you.

Biff

"Joe Black" wrote in message
...
sorry i thought id better post this. i hope this explains it a bit better.
i
need the top matrix to be filled out by looking at the bottom matrix
according to sizes(topmost leftmost column/row).

240 301
240 $- $- $-
301 $- $- $-
421 $- $- $-
541 $- $- $-
661 $- $- $-

251 301 351
351 $15.00 $20.05 $20.56
451 $20.00 $23.61 $24.63
551 $21.00 $27.56 $29.35
651 $25.00 $32.47 $34.56
801 $30.00 $34.91 $36.95


"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

Oops, try this
http://www.findarticles.com/p/articl...5/ai_ziff40152

"Joe Black" wrote:

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

Are you sure about that link?

I get redirected!

Biff

"Barb Reinhardt" wrote in message
...
Oops, try this
http://www.findarticles.com/p/articl...5/ai_ziff40152

"Joe Black" wrote:

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

Try this

"Joe Black" wrote:

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