It works "as-is" on XL2k also.........

Vaya con Dios,
Chuck, CABGx3


"JulieD" wrote in message
...
Hi
your formula should do exactly what you request and it works when i test
it
... if you're using excel 2002 or excel 2003 can you spot what is wrong if
you click on the cell with the formula and use tools / formula auditing /
evaluate formula to step through it?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"JeaneIsaac" wrote in message
...
I have a very large worksheet that I am using the following vlook up on


=IF(ISNA(VLOOKUP(trim($D5),Dataentry!$D$9:$P$1508, 12,0)),0,VLOOKUP(trim($D5)
,Dataentry!$D$9:$P$1508,12,0))
I am using the results of the lookup for another calculation, so I
don't
want the return value from my look up to be N/A. Can you please tell me
how
to make it 0 instead of the N/A when there is no match in the lookup
sheet.
Thanks