Formulas Needed for spreadsheet with 2 worksheets for calculating $ based on 2 cell entry

Associate Reference Guide
1 = Steve Jones
2 = Ann Smith
3 = Jane Doe
4 = Paul Hack

Problem 1: Need formula for when I enter an ID number in a cell, a particular associates name appears in another cell based on the ID number entered.
In this attached spreadsheet I have 2 worksheets named; Board & Numbers
When I enter the ID number (1, 2, 3, or 4) into D11:D510 on “Board” the associate name is populated into F11:F510 based on the ID-Associate entered in D4:D7 & F4:F7 on “Board”

Problem 2: Need a formula to sum commission totals based on which sales person and monthly date entered. For the date I am using the format 8/15 (Aug 15th) without a year. The attached spreadsheet is the actual one I need it for so it will have the correct cells, sheet names, etc.
I would like to sum the total commission for a particular sales person from “Board” BE11:BE510 based on the sales person’s name that appears in cells “Board” F11:F510 and the date in cells “Board” BK11:BK510 into the appropriate cells on sheet name “Numbers” rows 27-39 based on the names in “Numbers” BL25, BX25, CJ25 or CV25 and the month F27:F39

Problem 3: Count the number of entries from “Board” D11:D510 based on what ID number is entered and if the letter “A” is entered into AJ11:AJ510 and place the results (Formula) into V4 on “Board”

Can You Help?

Associate Reference Guide
1 = Steve Jones
2 = Ann Smith
3 = Jane Doe
4 = Paul Hack

Problem 1: Need formula for when I enter an ID number in a cell, a particular associates name appears in another cell based on the ID number entered.

When I enter the ID number (1, 2, 3, or 4) into D11:D510 on “Board” the associate name is populated into F11:F510 based on the ID-Associate entered in D4:D7 & F4:F7 on “Board”

First time answering but I think this could help...

try writing =IFERROR(VLOOKUP(D17,Numbers!$A$12:$O$15,3,FALSE),"") on F17 hopefully it's what you are looking for.



Thank you,
Jack

Thanks Dibbins!!

As for the simpler formula, I'm just use to working with multiple sheets

Thanks,
Jack