Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Named Range references in function formulas
I have a spreadsheet in which I have a series of named ranges that each refer
to a series of cells on a given row of the spreadsheet. For instance row101=Development!$C$2:$M$2,row102=Development!$C $3:$M$3, etc. I am interested in using these "Names" in "Match" and "Lookup" functions. They work fine when I type the names in the functions or when I select the corresponding ranges. However what I was really hoping to be able to do was to have a user enter the numeric part of the "Name" in a cell (i.e. 101) and somehow be able to use this value to "generate" the "Name" and then use that in the "Match" & "Lookup" functions. I can "generate the "Name" using the concatenate function but it doesn't work in the "Match" and "Lookup" functions - they result in "# value" errors. I am convinced there is something simple that I am missing but can't figure out how to get this to work. It may be that this approach won't work at all, if this is the case any suggestions on how I might accomplish this type of lookup based on a user input value would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating formulas with named cell references in a different worksh | Excel Worksheet Functions | |||
Named formulas in CHOOSE need to be Relative references when paste | Excel Worksheet Functions | |||
Confused about relative references in named formulas | Excel Worksheet Functions | |||
How to find all formulas that used a certain named range | Excel Discussion (Misc queries) | |||
dynamic named range function | Excel Worksheet Functions |