# 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. ## 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. 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
 B10 =

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

#### Posting Permissions

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