Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Formula
=a*b*MONTH Results in error if Named Range is picked up from a drop down box eg: Jan set of values Feb set of values Putting named range in formula directly works fine. Point to a cell called month where users select the appropriate month yields errors How do I get the range values passed correctly to the formula if the drop down box is named MONTH? Where Month = Drop Down and Month is a named range Workarounds?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Named range as chart data reference (error) | Charts and Charting in Excel | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
Named range error | Excel Discussion (Misc queries) | |||
VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
Offset delivers value error with Named range | Excel Worksheet Functions |