Hi
Right click on any sheet tab and choose View Code.
This will invoke the
VB editor.
If the Immediate window is not visible, type Control+G to invoke it.
In the Immediate window, type
names("actuals").visible=true
and hit Enter.
Now go to InsertNamesDefine and see if it shows up in the list.
Your formula
=IF(ISNUMBER(VLOOKUP($W8,actuals,X$6,FALSE)),(VLOO KUP($W8,actuals,X
$6,FALSE)),0)
could run quicker if you used
=IF(COUNTIF(actuals,$W$8),(VLOOKUP($W8,actuals,X$6 ,FALSE)),0)
provided it is the presence of W8 that could be the problem, rather than
the value offset X6 columns from the W8 value.
--
Regards
Roger Govier
"Excel_Oz" wrote in message
oups.com...
Hi,
No it doesnt go anywhere, thats why I am confused. Any Idea's?