Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel for Billing
Hi,
I run a small business selling various lab related equipment. I would like to use Excel for my billing, and would like the following: I want to be able to enter a catalog number, and have the program automatically enter the item name and price, based on that catalog number. I thought of nesting multple IF functions within one formula, but my catalog consists of over 100 items. What would be the most efficient way of doing this? Thanks, Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel for Billing
I use Vlookup function in my business for this task. You need to have
a list of your items with catalog numbers in leftmost column and desription and prices in following columns. Geegee Paul wrote: Hi, I run a small business selling various lab related equipment. I would like to use Excel for my billing, and would like the following: I want to be able to enter a catalog number, and have the program automatically enter the item name and price, based on that catalog number. I thought of nesting multple IF functions within one formula, but my catalog consists of over 100 items. What would be the most efficient way of doing this? Thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Billing Statement Help | Excel Worksheet Functions | |||
Frequency of Billing | Excel Worksheet Functions | |||
construction billing | Excel Programming | |||
Is there a billing legder template for excel | New Users to Excel | |||
Where can I find a Billing Statement Template for Word or Excel? | New Users to Excel |