Try

=IF(C25<"",IF(ISNA(VLOOKUP(C25,Product_Data,2,FAL SE)),"",VLOOKUP(C25,Product_Data,2,FALSE)),"
")

HTH

Bob


"gibbylinks" wrote in message
...
Hi, I use a spreadsheet for invoicing and have a product code entered into
a
column when a product (in column C) is selected.

I also sometimes use this column to put a description in rather than pick
a
product.

Can my formula be modified to avoid the #N/A appearing in the product code
?

Current formula is

=IF(C25<"",VLOOKUP(C25,Product_Data,2,FALSE)," ")

Thanks