just thinking...does each of your invoice spreadsheet needs to be saved each
time you create one with a served invoice number ? If you do, better clean
the non-servable formula....Just try to maintain a template filled with the
formula for your next invoicing....

"Bev Greene" wrote:

I have used the VLookup function on an invoice that will print the price and
description of an item when the item number is typed in. I want to removed
the #N/A from the invoice when the lines are blank. I was told to use the IF
function.

My lookup function is =VLOOKUP(A24,Product!A8:D14,2)

If I add the IF function to it-- would it look like

=IF(A24="","")=VLOOKUP(A24,Product!A8:D14,2) ?

Or just where would the IF formula go and did I type it correctly to say if
the cell is empty?

Thanks
Bev