| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP using a named range returns #VALUE!
Excel 2003 v.11
=HLOOKUP(W2,WholeYear,13) = #VALUE! Where WholeYear is a named range Jan:Dec!$L$2:$AP$17, that spans 12 worksheets. The first row in the range (Row 2) contains the 365 days of the year, in order. Everything about this looks correct, and it works if I refer to a signle sheet, but I am getting a Value error when searching the whole year. Can anyone help? I'm really stuck. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range matching multiple named Ranges | Excel Discussion (Misc queries) | |||
| Dynamic Named Range with blank cells | Excel Discussion (Misc queries) | |||
| How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
