"#N/A" -- can I convert to a "0" (zero)?
 

I have just learned to pull query data into a spreadsheet through VLOOKUP.
However some years have no data in the query and it returns an #N/A in the
cell. I cannot figure out how to convert those to a '0'. Any master of
Excel out there have any suggestions?

Thanks in Advance!
Branchie

"#N/A" -- can I convert to a "0" (zero)?
 

You need to trap the error: =IF(ISNA(VLOOKUP([your vlookup
formula])),0,VLOOKUP([your vlookup formula]))

Dave
--
Brevity is the soul of wit.


"Branchie" wrote:

I have just learned to pull query data into a spreadsheet through VLOOKUP.
However some years have no data in the query and it returns an #N/A in the
cell. I cannot figure out how to convert those to a '0'. Any master of
Excel out there have any suggestions?

Thanks in Advance!
Branchie

"#N/A" -- can I convert to a "0" (zero)?
 

=IF(ISNA(VLOOKUP(G2,C1:E24,2,FALSE)),0,VLOOKUP(G2, C1:E24,2,FALSE))


Gord Dibben MS Excel MVP


On Thu, 7 Dec 2006 12:56:01 -0800, Branchie
wrote:

I have just learned to pull query data into a spreadsheet through VLOOKUP.
However some years have no data in the query and it returns an #N/A in the
cell. I cannot figure out how to convert those to a '0'. Any master of
Excel out there have any suggestions?

Thanks in Advance!
Branchie