Hi, Thanks for your reply but i still do not get it.
Let me explain again

Lets say I have the below table on one sheet and the formula on another
seperate sheet
A B C D E
0.5 1.30 5.40 6.5 7.5 10.50
1.0
1.5
2.0 21.25
2.5

Lets say the user enter the following data,for row: C and Col: 2.0, so what
formula do i use to call out the value of 21.25.

The formula needs extract out the value of whatever information the user
keys in.

Kindly advise.

Thanks a lot

"Peo Sjoblom" wrote:

Row D?
You can use INDEX if you want the value where 2 coordinates meet

=INDEX(A2:D10,ROW(2:2),COLUMN(C:C))

will lookup what's in C3 (3 columns from left A included and 2 rows down
from row 2)

--
Regards,

Peo Sjoblom


"ST" wrote in message
...
I want to look up a value from a range of columns and rows.
For example, Wat is the value ast Column C Row D?

What is the fundtion to use?