I'm by no means an expert so please be nice
What I am trying to accomplish is this. I have a business, and I'd like to use Excel for issuing my receipts. What I would like to be able to do is under "Sheet 1" would be the receipt that I would be printing for my clients, "Sheet 2" would be the entire list of my inventory. Under column "A" I would like the name of the service "Service X" and under column "B" I would like it to remain blank, but this would be the field where I would put the charge/fee for the corresponding service (we have variable charges for each service, so there is no fixed amount).
Sheet B should look like this
--------A----------- B------------C
1 Service X $10.00
2 Service Y
3 Service Z $11.00
What I want is that whenever I put a dollar value next to a specific service Column A will be sent to my "Sheet A" under a specific column and Column B will also be sent to excel into another column. Under this example Row 2 has no dollar figure, so I don't want that to show up on "Sheet A"
example of what I want my receipt to look like
RECEIPT Sheet A
--------A-----------B---------C
1 Service X--------------$10.00
2 Service Z--------------$11.00
(listed format)
the simpe "=" function doesnt work for me because I have about 30 line items that they can purchase but some clients only opt for 2 or 3 so it wouldn't make sense to list them all.
Last edited by markquion; 11-11-2010 at 01:28 AM. Reason: corrected example
You have to use a lookup function. Vlookup or Index+Match. I can give you some examples in the attached file
rgds
johnjohns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks