#N/A outcomes in formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a spreadsheet with multiple sheets and using the Vlookup formula
to pull certain data from the sheets. The VLookups are working fine, but I
then have to add a certain number of Vlookups together in one formula.
Again, I believe they are working fine, but some of the sheets do not have
the lookup field in it, so therefore return #N/A. Is there anyway i can use
an IF formula or something similar, around the Vlookup formula so the #N/A
would be returned as 0.00 instead and would therefore add up as normal? I
thought I had it sussed, but because the #N/A is not text, it won't recognise
it in the IF function.

Thanks in advance for you help
 
I am using a spreadsheet with multiple sheets and using the Vlookup formula
to pull certain data from the sheets. The VLookups are working fine, but I
then have to add a certain number of Vlookups together in one formula.
Again, I believe they are working fine, but some of the sheets do not have
the lookup field in it, so therefore return #N/A. Is there anyway i can use
an IF formula or something similar, around the Vlookup formula so the #N/A
would be returned as 0.00 instead and would therefore add up as normal? I
thought I had it sussed, but because the #N/A is not text, it won't recognise
it in the IF function.

Thanks in advance for you help

Yeah, just use =if(isna(vlookup formula),0,(vlookup formula)
 
=IF(ISNA(VLOOKUP),0,VLOOKUP)

will return zero instead of #N/A

or if all you want is being able to sum the results of the vlookups without
getting an error you can use

=SUMIF(D2:D50,"<="&99^99)


where D2:D50 holds the results of the vlookups
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas #N/A 4
Set add function ignore #N/A 1
Remove #N/A Error 3
VLOOKUP returning #N/A result 2
VLOOKUP output 3
Return 0 instead of #n/a 1
Remove #n/a in vlookup to sum results 6
#N/A 5

Back
Top