xlookup or index match from another worksheet from 2 or 3 criteria

Hi, I almost got it but not close enough, so any help appreciated to make the formulas work for the scorecard.
I've colour coded the cells from the worksheets to help explain the flow.
Based on the criteria of the Month and Actual or Budget and the account name, such as Total Trading Income, I want it to return the value from the P&L sheet from the column of that month ie Jan, etc from the drop down at G12.
If possible, it would be great if the months name for LM in E12 and PM in D12 could be auto updated of their names and then also the data returned from the P&L worksheet for those months in the scorecard.
Also, the Total in M39 comes from the worksheet Aged Receivables, but the report from the accounting system sometimes adds columns or removes them, so the headings move columns, so a moving lookup and return is needed based on the headings / criteria, rather than a static value return.
Many thanks JB

Hi AliGW,
thanks for the welcome. I've read some of these posts before as help on excel but never used one, brave new world...
Many thanks for the formula.
That works for when I paste it into Scorecard G15, but when I copy it to cell F15 and align the criteria cell to Budget it returns a #N/A.
It also returns a #N/A if I leave it in G15 and change the criteria to F14 Budget instead of actual, as a sort of second check.
So, what I have wrecked in the formula?
Thanks
JB

For the budget you could do the following fix.

Formula:

Please Login or Register  to view this content.

awesome, thank you. With the alignment part, is that because the Jan is the centre column, but Budget is one column to the left?
Therefore, would it be more robust to call each column in its full name, such as Jan Actual and Jan Budget...?

ah, sorry, just cottoned on to what your image inclusion says, got it and will do. many thanks, appreciate it.

Glad to have helped.