Name Manager For A Lookup

[Faraz A. Qureshi]

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.

 

[Shane Devenshire]

Hi,

If the item in A1 is to be found in the first column of the named range then

=VLOOKUP(A1,myRange,3,TRUE)

should do the trick, or the slightly shorter version

=VLOOKUP(A1,myRange,3,)

 

[Faraz A. Qureshi]

Sorry Shane,

But it seems like I was unable to clarify the example.

The cell could be any, not only in Column A. Fopr example if you insert the
formula in Z100, the Y100 is sought to be considered.

 

[Jacob Skaria]

Faraz

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

If this post helps click Yes

 

[Faraz A. Qureshi]

Thanx Jacob!!!

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

XClent!