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.