Can I use vlookup to find data in a named range? I currently have a
list of locations in col A and monthly sales data in cols AP:BB.
(There's a heap of other data in the intervening cols.) I have
included cols A and AP:BB in a range I have named "Sales_FY06".

When I try to build a vlookup formula using the wizard and typing the
range name into the table array field it displays #VALUE against that
field.

My formula looks like this:

=VLOOKUP(B35,'KPIs REPORTS MASTER - FORMULA
TESTING.XLS'!Sales_FY06,10,FALSE)

Thanks in anticipation,

Trish


--
tuph
------------------------------------------------------------------------
tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390
View this thread: http://www.excelforum.com/showthread...hreadid=544929