formula(s)

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

Guest

Is there anyway to not display '#n/a' when use a 'vlookup' formula?(or maybe
display a '0' instead of a 'n/a')
 
=IF(ISNA(YourVlookupFormula),"",YourVlookupFormula)

or, replace the "" with a zero

Vaya con Dios,
Chuck, CABGx3
 
Ok it did not work ... it change the one's with information to blank to.

this is my formula

=IF(VLOOKUP(E2,'4 Jan 07'!$D:$L,1,FALSE)=E2,VLOOKUP(E2,'4 Jan
07'!$D:$L,9,FALSE)," ")


were would insert the 'isna" part to my formula?
 
=IF(ISNA(IF(VLOOKUP(E2,'4 Jan 07'!$D:$L,1,FALSE)=E2,VLOOKUP(E2,'4 Jan
07'!$D:$L,9,FALSE)," ")),"",IF(VLOOKUP(E2,'4 Jan
07'!$D:$L,1,FALSE)=E2,VLOOKUP(E2,'4 Jan 07'!$D:$L,9,FALSE)," ")

Vaya con Dios,
Chuck, CABGx3
 
Try this:

=IF(COUNTIF('4 Jan 07'!$D:$L,E2),VLOOKUP(E2,'4 Jan 07'!$D:$L,9,FALSE)," ")
 
An alternative is to use COnditional Formatting to hide the #N/A
best wishes
 
You must log in or register to reply here.

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

VLOOKUP - 0 instead of # N/A 8
Formulas #N/A 4
Replace #N/A with 0 1
getting the sum of a column with #N/A values in it 2
#N/A outcomes in formulas 2
#N/A 5
Return 0 instead of #n/a 1
VLOOKUP Error 4

Back
Top