Use the mouse and select the ranges etc and excel will give you correct
sheet name correct workbook name and correct named range, have both
workbooks open while doing so.

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"tuph" wrote in message
...

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