| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range
2007 with compatibility with 2003
In my data validation I have the following formula =IF(C23="",Settle_List,INDIRECT(payout_opt)) payout_opt can be several options If the range name of "selected" payout_opt is static =Model_info!$M$3:$M$14 everything works fine, bue whent I want to change the range name dynamically to =OFFSET(Model_info!$M$3,0,0,Model_info!$M$37,1) or =Indirect("Model_info!$M$3:M"&M37+2) it doesn't (The dropdown function only lists the first options. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Linear Mode
