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')