Data Validation & Two selections from Two unique cells populating a third list

What I have is a a pretty long data validation list for selection, in which one cell's DV list is populated by another. Simple stuff. Well, I'd like to have that one cell (J5) have its data validation list populated by the result of two selected values (and have duplicates removed).

The formula I currently have for J5 is
=OFFSET(Class_List!$D$1,MATCH(J2,Class_List!$D:$D,0)-1,1,COUNTIF(Class_List!$D:$D,J2),1)

And can be seen here, as only options from J2 are included in the list.
0c7e6eeaf3.png


So I'd like to make a selection in J2 and J4, then have my J5 list include all (sans duplicates) of the yellow entries in the 2nd screenshot. Have I approached this in the wrong manner?
3011ffb60b.png

8e8dc9ee43.png


*Edit* Here's my doc FE13 LAMS V_1_4.xlsm

Hey, I've made a similar question....
http://www.excelforum.com/excel-prog...-criteria.html
see if you can adapt for you!
Tell me if you know how to do macros as well...I can do that with macros.

Ok, take a look on the post. It's a formula based solution.

I created a separate list that is created from column E of Class_List by the choices in Battling_Teams!J2 and Battling_Teams!J4 on Class_List!$u$2:$u$100. I copied the values of J2 and J4 to Class_List!T2 and T3 and used this array formula to create a dynamic list.

Formula:

Please Login or Register  to view this content.

The Data Validation formula for Battling_Teams!J5 is:

Formula:

Please Login or Register  to view this content.

I used another column (V) on Class_List to eliminate the duplicates that showed up with your testing of the data. This creates the same kind of listing as before but without the duplicates. It is completely determined by the first two choices in Battling_Teams! column J.

Thank you for the feedback.

Instructions for marking SOLVED:

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

The thread tools are just above your first message.