lookup table with 2 lookup values????

[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
1
2
3
4
5
6
7 ?
8
9
10

[girth69]

that table is poor im sorry, lol, the question mark is supposed to be under colum d and in row 7.......im new to all this sorry.

thanks in advance.

[arthurbr]

Hi,
you can attach a zipped sample of your file with what you want to achieve.