Thread: VLOOKUP
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ardus Petus
 
Posts: n/a
Default VLOOKUP

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

HTH
--
AP

"gordo" a écrit dans le message de
ups.com...
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