One way:

name your table, say, "table" (from "Apples" to $150, 3 rows by 7
columns). Then:

=INDEX(table, MATCH(Type, INDEX(table,,1), FALSE), MATCH(Value,
OFFSET(table, MATCH(Type, INDEX(table,,1), FALSE)-1,1,1,3), TRUE)+4)

In article ,
pdberger wrote:

Good morning --

I'm trying to design a lookup table to work like this:

Type Apples
Value 35

Value Earnings:
Range 1 Range 2 Range 3 Range 1 Range 2 Range 3
Apples 10 25 50 $50 $75
$100
Oranges 25 50 75 $100 $125
$150
Lemons 30 60 80 $75 $150
$200

The value returned would be $75 (Earnings, Range 2, Apples).

Thanks in advance, and happy holidays.