Thanx Jacob!!!

Never had an idea of using ADRESS()!!!

XClent!
--

Best Regards,

Faraz


"Jacob Skaria" wrote:

Faraz

Do you mean..
=INDIRECT(ADDRESS(ROW(),COLUMN()-1))

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

What sort of OFFSET+LOOKUP combination formula should be named so that when
simply used in B1 as:

=NAME

would work as looking into a named range and returning the corresponding
entry from it's third column, the cell on the left, i.e. A1?

Thanx in advance.

--
Best Regards,

Faraz