suitable reference/lookup function?

[melvin]

Hi folks,

I am looking for a function similar to the vlookup function that ca
return the value of the cell where a particular row and column cross.
I would also like the rows and columns to be referred to using cel
values in these respective rows and columns.

For instance, I am using the vlookup function as follows

VLOOKUP(A10,data,5,FALSE)

where, A10 refers to a cell value and 5 refers to the column number.


I am looking for a 'function' that can use two cell values, eg:

FUNCTION(A10,data,E8,FALSE)

where, A10 refers to a cell value in the row and E8 refers to a cel
value in the column. The result would be the cell value where the ro
(indicated by A10) and the column (indicated by E8) cross.

Does anyone how this is possible??

Many thanks for your time

Best regards

 

[Frank Kabel]

Hi
you may try something like the following:
=INDEX(data,MATCH(A10,$A$1:$A$100,0),MATCH(E8,$A$1:$F$1,0))

 

[melvin]

Frank,

That worked a treat!

many thank