Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default Name Manager For A Lookup

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Name Manager For A Lookup

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,)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default Name Manager For A Lookup

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.
--
Best Regards,

Faraz


"Shane Devenshire" wrote:

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,)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Name Manager For A Lookup

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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default Name Manager For A Lookup

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add-in manager tleehh Excel Worksheet Functions 1 March 31st 09 11:54 PM
List Manager Adminservices Excel Worksheet Functions 1 March 28th 07 11:00 PM
Name Manager F. Lawrence Kulchar Excel Discussion (Misc queries) 3 November 16th 06 08:28 PM
Scenario Manager Tony0z New Users to Excel 1 April 12th 06 02:34 AM
Scenario manager and IRR PeterW Excel Worksheet Functions 0 February 15th 06 03:04 AM


All times are GMT +1. The time now is 01:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"