Since you seem to want the next highest depth when an exact match is not
found you need to reverse the order of your table.

See this screencap:

http://img409.imageshack.us/img409/6089/lookuptp4.jpg

--
Biff
Microsoft Excel MVP


"neil" wrote in message
...
Hi,

I have created a matrix of rates for a combination of diameters (rows) &
depth (columns). Increments of the column data is in 50mm, while the dia
(row
data) is fixed values. The matrix is hidden to users.

Users provide a combination of diameter & depth, and require the rate to
be
displayed to them. While the diameter data is usually a set value that is
already defined in the price list, the depth can be any value.

The spreadsheet looks somewhat like this
Depth upto
Dia 100 150 200 250 300
10 1 2 3 4 5
20 2 4 6 8 10
30 3 6 9 12 15

Suppose a user wants to know the price for 10dia by 220 depth, I need to
provide the intersect of row 1 & column 4 (result 4).

Can you please help me do this two-way lookup?