double lookup functions

[girth69]

Hi, i have to get a lookup value from a table using 2 values.....

imagine the table has values down the vertical column 1-10, and then across the top a-j, with all the data i need in the table between.....how would i get a formula to display the lookup thats in row 7 as well as column d??

ive tried to put in a example table below

thanks

a b c d e f g h i j
1
2
3
4
5
6
7 ?
8
9
10

[StephenR]

One way:

=INDEX(B2:K11,MATCH(7,A2:A11,0),MATCH("d",B1:K1,0))

There's a quicker way using space as an intersect operator but I can't remember how that works. Somebody else may.

[girth69]

thanks, but what i really need isto be bale to drag the formula down a column on another sheet....

basically i have 2 columns on another sheet. the first with the numbers in and the 2nd with the letters.....i want the 3rd column to be a formula which returns the value in the table i showed earlier that falls under the specific combination of number and letter.

e.g

12 a = ?
8 d = ?

[arthurbr]

You opened the same thread in the Excel general forum.
It would be nice if you deleted it
Thx

[StephenR]

Have a look at the attachment.