Help with figuring out how to use multiple sheet data files

[koesherbacon]

I want to have a primary sheet that refers to two another sheet in the same document.

Basically, the person using the spreadsheet will tell the first sheet what data they're looking for from within the dataset contained in the second sheet and the third.

The first sheet will then have an area which it outputs which data matches the criteria.

Here's some specifics. It's for Pathfinder Deities. The user will input which domains they wish to use and the sheet will output which deities, if any, will be appropriate to select.

The second sheet contains all the Cleric Domains and which Deities are associated with them. The third sheet contains the alignment of each Deity.

If it was not obvious, in the first sheet, the player will indicate which Domains they wish to use for their character as well as the alignment of the deity they wish to use. Once they've indicated what their choices are, the first sheet will show which deities are available given their choices.

I'd prefer to do this without using macros, but if it's easier to use them, then I'll just have to go for it.

I'm really new at Excel programming so any advice you can give me will be welcome with open arms!

The screenshots are too large to post, so I'll just post my project:
https://www.dropbox.com/s/qiqcllwdl0vemz9/Pathfinder Deities' Domain Search.xlsx

Thank you so much!a

 

[sijpie]

HAve you tried to fill out your front sheet by hand?

i can imagine that the table 'Deities matching both Domains' will fit in a 10 row table, but the 'Deities matching Either Domain' will never fit in a 20 row table, some of the domains have way over 20 deities, and i need to add two of them.

Also trying to do this in only formulas is going to be a pig both in setting it up and in maintaining it.
I already had to write a little macro to set the range names for all the domains...