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

**KyleMaxwell** · 10-19-2018, 08:35 PM

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

**Bo_Ry** · 10-20-2018, 01:16 AM

Please add data to "Families (All)" E39:E68

and use "Cumulative Stats" D4

=VLOOKUP('Cumulative Stats'!B4,Table62,2,0)

**KyleMaxwell** · 10-20-2018, 12:31 PM

I can add the data on the "Families (All)" E39-E:68, but What I'd like for it to do is present the drop-down menu in D4

So it would look something like the attached picture, but vary based on what Family is selected

Example.PNG

With the suggested code, since there's no data in "Families (all)" E39-E:68, it just returns "0" instead of mirroring the drop-down options:

Example2.PNG

**JeteMc** · 10-22-2018, 01:06 AM

Hello KyleMaxwell and Welcome to Excel Forum.
I don't know of a way to mirror a drop down, so I believe that you will need to produce dependent drop downs, much as you have already done in cell B4.
For as many dependent drop downs as will be needed you might be interested in the the OFFSET function method explained in this article.
Let us know if you have any questions.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

Re: Trouble making one cell mirror a table reference drop-down list using another cell as

Re: Trouble making one cell mirror a table reference drop-down list using another cell as

Re: Trouble making one cell mirror a table reference drop-down list using another cell as

Thread Information

Users Browsing this Thread

Similar Threads

Cell reference from drop down list

Simple Macro that updates cell after making a selection in a drop down list?

reference a cell on multiple worksheets that has a drop down list.

[SOLVED] Cell reference based on another cell choice from a drop down list.

Excel 2007 : Drop down list Cell reference

Create drop list jump to reference cell

[SOLVED] Making the drop down list of a cell depend on another cell

Bookmarks

Bookmarks

Posting Permissions