Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded If Function in a Vlookup Function
=If(B15="","",VLOOKUP(B15,Products,2))
But if B15 does not appear in the products table, you will get an error (which in this case may be desirable). "Excel Student" wrote: 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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded If Function in a Vlookup Function
=If(B15="","",VLOOKUP(B15,Products,2))
Its often safer to use the 4 argument Vlookup set to false, unless you can be certain your source list will be sorted : =If(B15="","",VLOOKUP(B15,Products,2,FALSE)) cheers Simon "Excel Student" wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can we use multiple if with VLookup function | Excel Worksheet Functions | |||
vlookup Function Help Needed | Excel Worksheet Functions | |||
Pastable function using VLOOKUP? | Excel Worksheet Functions | |||
format cell based on results of vlookup function | Excel Worksheet Functions | |||
Vlookup w/Date Function | Excel Worksheet Functions |