Lookup a Cell Value

[nkvasan]

I have a table in which first row and first column represents the index. Based on row / column value, I want the lookup the cell where they intersect. I there a formula for doing this lookup?
_________________
Krithivasan

[noranthon]

It isn't clear to me what you intend but the INDEX function may serve. You could also look at the MATCH, VLOOKUP, HLOOKUP and LOOKUP functions.
_________________
search forum by month

[nkvasan]

I have a table like this:

2 4 6 8 10 12
10 0 5 7 9 12 13
20 5 8 9 10 17 14
30 4 3 2 7 8 2
40 7 7 3 9 7 8
50 9 8 7 6 5 4

First row and first coloum represents the key that will be entered. For example, If I enter key as 30 (row key) and 4 (column key), the result should be 3. In case I enter 40 and 2, the result should be 7.

Hope I am clear
_________________
Krithivasan

[noranthon]

The INDEX function is what you want. For your examples: =INDEX(MyTable;30;4) =INDEX(MyTable;40;2)
_________________
search forum by month

[nkvasan]

Thanks. I was able use the function with Match function to identify the column and row.
_________________
Krithivasan