View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel Student Excel Student is offline
external usenet poster
 
Posts: 1
Default Embedded If Function in a Vlookup Function

In an invoice I am making I want to use the vlookup function to populate a
description column and a unit price column when I type in a product item
number. I have a product table set up with the item number, description and
unit price on it. However, when I do not have an entry in the product item
numberin the invoice, an error message appears in the description column and
unit price column which does not make a good appearance for my invoice.

How to I put the =If(B15="","","") function in the vlookup function
=VLOOKUP(B15,Products,2)