In the IF statements the rows are hard coded but can not stay that way. As I stated, column A has a list of projects (could be a different view of different projects depending on the request), so the formula needs to read column A to match the project to the Master data tab to obtain the IF data.

If here is another way to do that I am open to suggestions.