Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add-in manager | Excel Worksheet Functions | |||
List Manager | Excel Worksheet Functions | |||
Name Manager | Excel Discussion (Misc queries) | |||
Scenario Manager | New Users to Excel | |||
Scenario manager and IRR | Excel Worksheet Functions |