Results 1 to 2 of 2

Look Up Function for X and Y axis

This is a discussion on Look Up Function for X and Y axis within the Excel Questions forums, part of the Question Forums category; I need help with a look-up function for the table structure below. My look up function will be based on ...

  1. #1
    New Member
    Join Date
    Aug 2004
    Posts
    22

    Default Look Up Function for X and Y axis

    I need help with a look-up function for the table structure below. My look up function will be based on a value for the X axis, in this case lets call it 2. The Y axis will be 5. In this example, I need the formula to return the value .388. How do I accomplish this?

    The table below is three columns wide with column headers 1,2,3, and 6 rows (Rows 1-6)

    Column (X Axis) Search Value 2
    Row (Y Axis) Search Value 5

    1 2 3
    1 0.010 0.022 0.023
    2 0.110 0.120 0.130
    3 0.095 0.299 0.423
    4 0.114 0.361 0.511
    5 0.123 0.388 0.548
    6 0.130 0.413 0.583

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,238

    Default

    How's this:

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book4___Running: 11.0 : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    1
    Table123
    2
    10.010.0220.023
    3
    20.110.120.13
    4
    30.0950.2990.423
    5
    40.1140.3610.511
    6
    50.1230.3880.548
    7
    60.130.4130.583
    8
    9
    Lookup
    10
    20.388
    11
    5
    Sheet1

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE A JavaScript ERROR WILL OCCUR.


    Formula is: =INDEX(B2:D7,MATCH(A11,A2:A7,0),MATCH(A10,B1:D1,0))

    Hope that helps,

    Smitty
    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

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