Hide #N/A

[Scott]

Is there a way to hide the #N/A result when using the VLOOKUP command in
Office 2003? I want to hide #N/A until I type in a value that gives me an
actual result .

THanks

 

[Scott]

PLEASE DISREGARD THIS POST...I received the answers I needed thanks!

 

[Dave O]

=IF (ISNA(your vlookup), desired response if NA, your vlookup)