Auto Populate Data values based on dependence of two drop-down lists

I am trying to create an easy fill spreadsheet for a game. I am looking to have data values auto fill based off of the entry of 2 prior drop down menus.

I would like to have values for "Move", "Str", "Spd", "Skill", "Armor", and "Value" auto populate after the "Race" and "Role" has been selected. Data for these auto fills I have put on Sheet2 while the main file itself is on Sheet1.

If possible I would like to have Value increase by 5 for every level in "Rank" on the sheet.

Can this be done in Excel. I don't care how it is done, so much as I would really like to learn how to do this. Hopefully this makes sense. Thank you.

Attaching the file as it stands currently.

Hi

You could try using a vookup to auto populate after race and role. However to do this you will need unique race and role names. then sort ascending by race.

hope this helps