+ Reply to Thread
Results 1 to 6 of 6

drop list matching corosponding values from another set of cells or tab

  1. #1
    Registered User
    Join Date
    09-25-2008
    Location
    canada
    Posts
    3

    drop list matching corosponding values from another set of cells or tab

    I used to create pretty intensive spreadsheets a few years back and knew excel very well. Unfortuantely that was several years ago and I am now stuggling on what should be VERY simple.

    I have a spreadsheet which I created to keep track of expenses. The fields are.

    DATE | NAME | ITEM | COST | QTY | SUBTOT |

    The ITEM and COST columns should come from a seperate source (other source columns or even another tab).

    Currently I have the items coming in via DROPLIST from a list of cells on the same spreadsheet. What I need is the COST cells to automatically fill once something is selected from the corosponding ITEM tab.

    ie. My TWO data columns are similar to this.

    ITEM | COST
    -------------------
    MAP | $5.00
    PEN | $1.00
    LOCKBOX | $25.00

    Now if I use the pulldown to select MAP I need the next colum (COST) to show $5.00 automatically.

    What am I missing? I have been playing with if statements etc. and running into problems. I know there is a simple way to do this, but I am drawing a blank.

    Any help would be greatly appreciated.

    THANKS!

    PS - I attached a quick screenshot of a basic idea of what I am looking at, although I would prefer to put the data on a second tab.
    Attached Images Attached Images
    Last edited by dravenb4u; 09-25-2008 at 02:26 PM.

  2. #2
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Try VLOOKUP - that's the usual way to match two items.
    Ed
    _____________________________
    Always learning, but never enough!
    _____________________________

  3. #3
    Registered User
    Join Date
    09-25-2008
    Location
    canada
    Posts
    3
    wow.. that was fast.. thanks for the suggestion.. I will look into this...

  4. #4
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Small example attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-25-2008
    Location
    canada
    Posts
    3

    That did it.>! Thanks

    Thanks so much.. that did the trick beautifully.

    Also, thanks for sending the sample.. it really helped with the proper context.

  6. #6
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    No problem - thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I use VBA to choose the source cells for a list with Data Validation?
    By baconcow in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-11-2008, 05:36 PM
  2. Drop down list with sub list
    By schoenerNSC in forum Excel General
    Replies: 5
    Last Post: 02-09-2008, 08:05 PM
  3. Drop down menus and blank cells
    By cptwhite in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2008, 09:18 AM
  4. Drop Down List Selections
    By Spencer in forum Excel General
    Replies: 3
    Last Post: 10-25-2007, 10:02 PM
  5. Help with list of values
    By Billx in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-24-2006, 01:25 PM

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.6.0 RC 1