View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bev Greene Bev Greene is offline
external usenet poster
 
Posts: 3
Default VLOOKUP with IF function

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