This was not meant to be taken literally

use


=IF(ISNA(your_formula),"",your_formula)

--


Regards,


Peo Sjoblom

"Michelle7890" wrote in message
...
Do I need = in there somewhere- I am getting some sort fo formula error??

"Sheeloo" wrote:

IF(ISNA(VLOOKUP()),"",VLOOKUP())

if you have Exel 2007 then
IFERROR(VLOOKUP(),"")

Replace VLOOKUP() with your VLOOKUP formula
--
Always provide your feedback...


"Michelle7890" wrote:

I am using vlook up in a list of accounts that varies from week to
week. How
can I make vlookup return a 0 or blank rather than the pesky N/A when a
prticular account is not on the list for the week? The N/A is messing
up my
total lines?