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