Identify intersection in named range

Hi

I've got a cloumn defined as a named range (say A1:A10, and say the named range is called DATA). Now, if I am in column B, I want to refer to the corresponding row in column A.

I've see somebody use something like:
DATA row, but that doesn't seem to work on my computer. I need to use this because I want to include the OFFSET function as well, e.g.
If(DATA row = offset(DATA row, -1, 0), true, false)

Thanks for the help

Freddy K

if named range data is a1:a10 , if you simply put =data in any row b1:b10 it will return the corresponding value from a1:10
also if you want the value of data row 4 say you can use anywhere on sheet

=INDEX(data,4) this will always return value from row 4 of range data