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