Vlookup that does not return #N/A
 

Is there a way to modify the vlookup formula so that it return a blank versus
#N/A.

Thank you in advance.

=IF(ISNUMBER(MATCH(A1,B1:B100,0)),VLOOKUP(A1,B1:C1 00,2,0),"")


Regards,

Peo Sjoblom

"carl" wrote:

Is there a way to modify the vlookup formula so that it return a blank versus
#N/A.

Thank you in advance.

try =if(iserror(vlookup),"",Vlookup)


"carl" wrote:

Is there a way to modify the vlookup formula so that it return a blank versus
#N/A.

Thank you in advance.

On Fri, 10 Jun 2005 12:42:03 -0700, "carl"
wrote:

Is there a way to modify the vlookup formula so that it return a blank versus
#N/A.

Thank you in advance.


=IF(ISNA(your_vlookup_formula),"",your_vlookup_for mula)


--ron