Question Locked

IF and VLOOKUP formulas

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a invoice worksheet and product pricing worksheet. In the Invoice worksheet I got the Item #, Description, Unit Price ,and Extended Price columns.I want to know how to do a IF and VLOOKUP formula to test for an empty cell in Item #. If the cell is empty, The description,Unit Price, and Extended Price cells are left blank. The VLOOKUP function uses the item number to obtain the appropriate description and unit price form the Product Pricing worksheet. I also have to place the appropriate formulas in the Description, Unit Price, and Extended Price cells.

2 replies

by dnhak

=IF(ItemNo="","",VLOOKUPFormula)

ItemNo = The Cell Address is where the Item # will be entered

"" = Empty cell

VLOOKUPFormula = is the vlookup you want to do if the Item No cell in not empty

This discussion is closed to new replies.