G
gibbylinks
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
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