Results 1 to 6 of 6

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

Threaded View

  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.

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