Pulling Data from two separate sheets based on criteria on both those sheets

In my attached workbook, I have 3 sheets (Custom Auction Settings, Draft Board and Values). I want to reference data from both Custom Auction Settings and Values to the Draft Board sheet.

Depending on what is selected in the drop down menus of the Custom Auction Settings for cells C9 and C10, I then want columns G, H or I to fill based on the info used in the values sheet that corresponds with what's in the drop down menu of the Custom Auction Settings C9 and C10.

Example, if Mixed 5X5 is selected in the drop down menus, cell G13 of the Draft Board should read "42" because that is the value for the name in cell C13. If AL 5X5 is selected I would then want cell H13 to read "40" and so on and so forth.

Any help would be greatly appreciated. Thanks!

Originally Posted by nflsales

G13=IF('Custom Auction Settings'!$C$9<>G$11,"",INDEX(Values!$B$3:$E$13,MATCH($C13,Values!$B$3:$B$13,0),MATCH('Custom Auction Settings'!$C$9&" "&'Custom Auction Settings'!$C$10,Values!$B$3:$E$3,0)))
Try this and copy across

Perfect thanks a lot!