Do ensure that Analysis ToolPak add-in is installed and loaded by checking
Addins list in the Tools Menu.

EOMONTH needs the Analysis ToolPak add-in
--

Best Regards,
FARAZ A. QURESHI


"Chuck" wrote:

Hi,
I am a worksheet with some rather "involved" formulas. In trying to debug
them, I have been using the Formula Audit. But now I find that sometimes this
works and sometimes it shows me the value #NAME? The formula has no error,
but the Formula Audit box only shows the Evaluate and Close radio buttoms.
Step In/Step Out are grayed out. The formula appears below. Any ideas on what
is causing this?

=IF(HLOOKUP(EOMONTH(E$71,0),$E$11:$V$61,$A72,FALSE )=0,0,HLOOKUP(EOMONTH(E$71,0),$E$11:$V$61,$A72,FAL SE)*E$69/HLOOKUP(EOMONTH(E$71,0),$E$2:$V$8,7,FALSE))

--
Chuck