lookup ranges
lookup ranges
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: lookup ranges

  1. #1
    Guest

    Default

     
    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.


  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,767
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    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 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com