VLOOKUP

[gordo]

Hi,
Can someone please help me. I am using Vlookup to look up a table and
bring nack relevant information. When the information is not found
vlookup returns N/A.
Is there any way of vlookup returning an empty cell if no info is found


Rgds

Gordon

 

[Ardus Petus]

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(....))

HTH

 

[RODY]

=IF(ISNA(VLOOKUP(DATA)),"NO INFO",VLOOKUP(DATA))