Multiple IF Statements and Conditional Lookups
In this example below, I have one sheet.
Question1: I'm not sure if it is best to move Rows 10-14 to another sheet or to a different part of the sheet to utilize column heading names.
Question 2 IF Statements:
Jan Cost Column: What is the Cost (Cost A or Cost B) for each team member based on their status indicator (A or B) and the Jan Points value that fall between Min/Max points?
For example, John Smith has "A" status and has 4 points. John's cost is $100 for Jan Cost column. David should be $250.
Help Article Resources
Check out the Formula Handbook template!