lookup ranges

I am trying to find a cell from two ranges with a table like this

0-12 13-24 25+
0-100 a b c
101-200 d e f
200+ g h i

If my two inputs fall into both ranges (i.e. 123 and 15), I want to find "e".

Any ideas?

All help would be appreciated.

[Aladin Akyurek]

On 2002-03-11 02:38, Anonymous wrote:
I am trying to find a cell from two ranges with a table like this

0-12 13-24 25+
0-100 a b c
101-200 d e f
200+ g h i

If my two inputs fall into both ranges (i.e. 123 and 15), I want to find "e".

Any ideas?

All help would be appreciated.

I'd suggest to reexpress the values in row 1 and those in column 1 differently as shown below.

{"",0,13,25;
0,"a","b","c";
101,"d","e","f";
201,"g","h","i"}

where zeroes are real zeroes.

Lets say that A1:D4 houses the above sample data.

In E1 enter: 123 [ a column key-value/lookup value ]

In E2 enter: 15 [ a row key-values/lookup value ]

Use what follows to retrieve the value associated with E1 and E2:

=OFFSET(A1,MATCH(E1,A2:A4),MATCH(E2,B1:D1))



[ This Message was edited by: Aladin Akyurek on 2002-03-11 03:45 ]