formula(s)
 

Is there anyway to not display '#n/a' when use a 'vlookup' formula?(or maybe
display a '0' instead of a 'n/a')

formula(s)
 

=IF(ISNA(YourVlookupFormula),"",YourVlookupFormula )

or, replace the "" with a zero

Vaya con Dios,
Chuck, CABGx3



"VAP" wrote:

Is there anyway to not display '#n/a' when use a 'vlookup' formula?(or maybe
display a '0' instead of a 'n/a')

formula(s)
 

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?



"CLR" wrote:

=IF(ISNA(YourVlookupFormula),"",YourVlookupFormula )

or, replace the "" with a zero

Vaya con Dios,
Chuck, CABGx3



"VAP" wrote:

Is there anyway to not display '#n/a' when use a 'vlookup' formula?(or maybe
display a '0' instead of a 'n/a')

formula(s)
 

=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



"VAP" wrote:

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?



"CLR" wrote:

=IF(ISNA(YourVlookupFormula),"",YourVlookupFormula )

or, replace the "" with a zero

Vaya con Dios,
Chuck, CABGx3



"VAP" wrote:

Is there anyway to not display '#n/a' when use a 'vlookup' formula?(or maybe
display a '0' instead of a 'n/a')

formula(s)
 

Try this:

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


"VAP" wrote:

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?



"CLR" wrote:

=IF(ISNA(YourVlookupFormula),"",YourVlookupFormula )

or, replace the "" with a zero

Vaya con Dios,
Chuck, CABGx3



"VAP" wrote:

Is there anyway to not display '#n/a' when use a 'vlookup' formula?(or maybe
display a '0' instead of a 'n/a')

formula(s)
 

An alternative is to use COnditional Formatting to hide the #N/A
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme

"VAP" wrote in message
...
Is there anyway to not display '#n/a' when use a 'vlookup' formula?(or
maybe
display a '0' instead of a 'n/a')