+ Reply to Thread
Results 1 to 5 of 5

Associating cells adjoining a drop down list cell to another worksheet

  1. #1
    Registered User
    Join Date
    03-08-2016
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2

    Associating cells adjoining a drop down list cell to another worksheet

    I would like to have cells next to a drop down list cell associate and be placed on another worksheet.

    Example:
    Worksheet 1, B3-B256 is a drop down list.
    Worksheet 2, B3-B28 are cells to select items from Worksheet 1, B3-256

    Worksheet 1, C3-C256 & D3-D256 is associated data that is unique data to the same B cell (B3,C3,D3)

    I would like when a drop down list item is selected on Worksheet 2, B3=Worksheet 1 B100. B100 to Worksheet 2 B3, Worksheet 1 C100 to Worksheet 2 C3 & Worksheet 1 D100 to Worksheet 2 F3.

    I am sure this is very simple, I am just lost right now.

    Thanks for any help

    -jonaton9

  2. #2
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    352

    Re: Associating cells adjoining a drop down list cell to another worksheet

    hi mate,

    please upload a sample workbook.
    If answer helped you say Thanks by Add Reputation

  3. #3
    Registered User
    Join Date
    03-08-2016
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2

    Re: Associating cells adjoining a drop down list cell to another worksheet

    Udprocks,

    I have attached a sample of the file.

    Thanks!
    Attached Files Attached Files

  4. #4
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Associating cells adjoining a drop down list cell to another worksheet

    is this what you wanted.
    Attached Files Attached Files

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Associating cells adjoining a drop down list cell to another worksheet

    Here is a solution that uses Index and Match. Delete the formula from the columns not required to have formulae. The Cost title on Sheet2 has a trailing space that must be eliminated.
    Enter this in Sheet2!C2 and fill across and down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Replies: 1
    Last Post: 09-10-2013, 06:03 PM
  2. Associating a cell value with several cells below... please read.
    By Steven8294 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 11:19 AM
  3. Replies: 3
    Last Post: 02-26-2013, 12:54 PM
  4. Drop Down List to Go to the Cell on the Worksheet
    By mheej in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2012, 12:35 AM
  5. Dropdown list bringing adjoining cell data
    By lozkane in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2010, 04:41 AM
  6. Linking drop-down data to adjoining cells
    By Nreese11 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-23-2010, 09:40 PM
  7. Associating prices with drop down list
    By Cassanetti in forum Excel General
    Replies: 2
    Last Post: 11-01-2007, 04:12 PM
  8. [SOLVED] Search range of cells, find a value, output adjoining cell. How?
    By nyys in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2006, 09:55 AM

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