VLOOKUP returning #N/A
Thanks Peo...
--
Always provide your feedback...
"Peo Sjoblom" wrote:
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?
|