Change cells based on 2 different criteria (VLOOKUP/IFS not helping)

[wizardofnothing]

Hi everyone,

I have this task to autofill a table (profit or loss statement) of the respective GL codes which updates as I change the month. Please see the attachment.

Any help or advice as to how to get to the desired result would be highly appreciated.

Let me know if you need further clarification.

Many thanks!
Cheers

[6StringJazzer]

Put this formula in B5 and copy down:

=SUMIFS('Raw Trial Balance'!C:C,'Raw Trial Balance'!A:A,'Profit or Loss'!A5,'Raw Trial Balance'!B:B,'Profit or Loss'!$B$1)

[wizardofnothing]

What a life saver you are 6StringJazzer!

I feel so stupid for not thinking about this formula before, even though I've used it a million times. smh

Much appreciated, thank you.