| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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') |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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') |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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') |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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') |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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') |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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') |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
