Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HLOOKUPs returning an NA value
Hi,
I have two HLOOKUP formulae and both are returning an NA value: a) =HLOOKUP(E$2,'FY09 Monthly'!D2:BL147,$A5,0) and b) HLOOKUP(E$2,TestNameRange,$A5,0) The first one (a) works but when I copy it to the next cell, I get an NA error: =HLOOKUP(E$2,'FY09 Monthly'!D3:BL147,$A5,0) In the second one (b), I have given a range a name and that doesn't work either. Does any one have any ideas? Thanks, Nadia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining HLookups &VLookups | Excel Discussion (Misc queries) | |||
Using VLOOKUP and HLOOKUPS with named ranges | Excel Programming | |||
=if returning 0 | Excel Worksheet Functions | |||
nesting if > 7 or using hlookups in a vlookup | Excel Worksheet Functions | |||
Hlookups + Vlookups | Excel Worksheet Functions |