+ Reply to Thread
Results 1 to 2 of 2

Thread: how to list items from different cell that contains values?

  1. #1
    Registered User
    Join Date
    11-11-2010
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2003
    Posts
    1

    how to list items from different cell that contains values?

    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

  2. #2
    Valued Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    504

    Re: how to list items from different cell that contains values?

    You have to use a lookup function. Vlookup or Index+Match. I can give you some examples in the attached file

    rgds

    johnjohns
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0