I understand that you relationship between sources of information is with the fields "Account Executive Name" and "Market"... My proposal is to have a single source of data and that you do not have to do the relationship within the spreadsheet....

Actual:

Expectation: (Only One)

in this way your field "[This Year Net]" would not be an aggregation and you could call it in the IF funtion.