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')
display a '0' instead of a 'n/a')
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
=IF(ISNA(YourVlookupFormula),"",YourVlookupFormula)
or, replace the "" with a zero
Vaya con Dios,
Chuck, CABGx3
or, replace the "" with a zero
Vaya con Dios,
Chuck, CABGx3
G
Guest
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?
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?
G
Guest
=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
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
G
Guest
Try this:
=IF(COUNTIF('4 Jan 07'!$D:$L,E2),VLOOKUP(E2,'4 Jan 07'!$D:$L,9,FALSE)," ")
=IF(COUNTIF('4 Jan 07'!$D:$L,E2),VLOOKUP(E2,'4 Jan 07'!$D:$L,9,FALSE)," ")
B
Bernard Liengme
An alternative is to use COnditional Formatting to hide the #N/A
best wishes
best wishes