Dependent drop down from table?

[JClayborn]

Hi everyone. I have a bunch of information in a single table. I want to use 2 drop-downs and then a Vlookup with indirect function to call that data out on another part of the sheet. Everything that I've seen so far shows making dependent lookups based on making multiple tables. I can't do that. It needs to work from one table.

I'm trying to make a battle calculator for a play-by-email game. So the first part of the table is a list of all of the units at the battle and their attributes. On the same line, next to that is where the information will go for the unit the first unit is attacking. Since every unit is listed in the initial table, it can just pull that data from the table.

[FONT=arial, sans, sans-serif]For example , the battle table would have this information on the left side.
[/FONT]<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD]Nation[/TD]
[TD]Type[/TD]
[TD]Unit[/TD]
[TD]Health[/TD]
[TD]Fire[/TD]
[TD]Man[/TD]
[TD]Skill[/TD]
[/TR]
[TR]
[TD]Karvipa[/TD]
[TD]Air[/TD]
[TD]KA-TF-001[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Karvipa[/TD]
[TD]Air[/TD]
[TD]KA-TF-002[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Karvipa[/TD]
[TD]Air[/TD]
[TD]KA-TF-003[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Karvipa[/TD]
[TD]Air[/TD]
[TD]KA-TF-004[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Killia[/TD]
[TD]Air[/TD]
[TD]KI-GF-001[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Killia[/TD]
[TD]Air[/TD]
[TD]KI-GF-002[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Killia[/TD]
[TD]Air[/TD]
[TD]KI-GF-003[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Killia[/TD]
[TD]Air[/TD]
[TD]KI-GF-004[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1
[/TD]
[/TR]
</tbody>[/TABLE]

On that first line, I want to be able to select a target for unit KA-TF-001. So, first I'd have the drop-down populate the nations that are present. In this case, I'd select Killia. For the second drop down I want it to show only the units that belong to Killia in that menu. From there, I can use a Vlookup with an indirect function to fill out the rest of the fields, but I'm not sure how to do that second drop down.

Any help would be appreciated.

 

[JClayborn]

I can't seem to find any tutorials that suggest this is even possible. But, when you create a Pivot Table you are able to do exactly the type of filtered drop down that I am trying to replicate. I just need to figure out how to do it outside of a pivot table.

 

[JClayborn]

Its all good. I figured it out. I was trying to do this: https://www.excel-university.com/slicers-as-an-alternative-to-conditional-drop-downs/

 

[Yongle]

Welcome to the forum and thanks for posting a link to your solution