Dynamic dropdown menu based on two criteria

Hi All,

Trying to find a simple answer to a complex (for me) problem.

I'm trying to create a downdown box, with a list of menus which are determined by a combination of two criterias.

Example -
Criteria 1: One gaming publisher (EA or Ubisoft or Activision)
Criteria 2: One format (PS3 or X360 or PC)
Dropdown Menu: List of all known game titles (All PS3 titles by EA or All PC titles by Activision)

So, the dropdown menu will list different games depending on the combination of the two criterias.

The source data is a table format, listing each game by format by publisher.

PS - I have no idea about VBA so I'm hoping for a manual formula solution.

Cheers

I have a table of game titles, with their format and publisher info.

Darsk,

I think this method has been covered in a couple other posts, but none the less here is a small sheet for you to use as a sample. This method uses vlookup and if to create a dynamic named range. It is a tiny bit laborious, but outside of VBA, I don't know a faster way.

http://www.sociopoly.com/DynamicLookup.xlsx

Cheers

hi jrockdown,
so close! but thats only because i may need to execute more than 1 search at one time, within a table.
your formula works but one to create one dynamic list at a time. if i wanted to create more searches in the rows underneath, while maintaing the original entry, it wouldn't work as i would need to create a new list to create a second drop list from.

scottylad2,
i've attached a file which has two tabs:
1. table
2. source data

so, the criteria 1 determines the drop list for criteria 2, which determines the drop list for criteria 3. once criteria 3 has been selected, i'd like to begin a new search below it, and so on.

hope this helps. and thanks again

jrock,
btw the formula works but fails to sort the dynamic list. not sure if there's a formula to sort it as well, but i worked around it easily enough but sorting the original data

sorry guys, still need help on this one.
see above for the worksheet.
many thanks

Originally Posted by Darsk

hi jrockdown,
so close! but thats only because i may need to execute more than 1 search at one time, within a table.
your formula works but one to create one dynamic list at a time. if i wanted to create more searches in the rows underneath, while maintaing the original entry, it wouldn't work as i would need to create a new list to create a second drop list from.

scottylad2,
i've attached a file which has two tabs:
1. table
2. source data

so, the criteria 1 determines the drop list for criteria 2, which determines the drop list for criteria 3. once criteria 3 has been selected, i'd like to begin a new search below it, and so on.

hope this helps. and thanks again