Hello Dear Excel Mates,

I have a table (attached) where i need to to auto populate Net Sales values with multiple conditions. This is tearing my brain down. I hope the excel mates in here can help me solve this.

much appreciated