Results 1 to 4 of 4

Trouble making one cell mirror a table reference drop-down list using another cell as ref.

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2018
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2016
    Posts
    2

    Trouble making one cell mirror a table reference drop-down list using another cell as ref.

    Okay, so what I'm doing is making a spreadsheet for a role playing game to assist with character creation. You'll probably chuckle at the mess of tables and array of data, but I'm just working with what I know - which isn't much. In the cell D4 I want a drop-down list displayed that uses the name in B4 so someone can select from the correctly listed data in the drop-down. Table 62 on page "Families (All)" has the list of names in one column with the correct drop-down lists in the next. (D39 & E39, respectively)

    It doesn't matter what I try though, I can't get the cell in D4 of the "Cumulative Stats" (first) page to show the corresponding cell on Table 62.

    Please enlighten me with you geniusesness! Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cell reference from drop down list
    By seanpmac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2014, 07:33 PM
  2. Simple Macro that updates cell after making a selection in a drop down list?
    By Vikestand in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2013, 04:37 PM
  3. reference a cell on multiple worksheets that has a drop down list.
    By TrendWendy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-04-2013, 04:26 PM
  4. [SOLVED] Cell reference based on another cell choice from a drop down list.
    By enoch5939 in forum Excel General
    Replies: 2
    Last Post: 12-07-2012, 12:04 PM
  5. Excel 2007 : Drop down list Cell reference
    By Schibbinger in forum Excel General
    Replies: 0
    Last Post: 08-22-2011, 03:10 AM
  6. Create drop list jump to reference cell
    By localhost in forum Excel General
    Replies: 5
    Last Post: 12-31-2007, 04:05 AM
  7. [SOLVED] Making the drop down list of a cell depend on another cell
    By Jarrod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2006, 01:45 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