I need help on a formula.
I have set up a worksheet with 24 tabs. 12 review sheets, one for each month. 12 sheets for the P&L each month.
I want to copy and paste the p and l into the relevant month and have the data extract into the review sheet.
On the p and l, there are various cost centres. In the cost centres there are various spend categories. Some of the spend categories repeat so I need a formula that ensures it pulls the data from the correct cost centre AND spend category. I used a v look up with an if error but it hits a wall when the spend categories repeat. In the image, you will see that Uniforms and Footwear as an example appears in two cost centres, so V Look up only finds the first one. I need it to find the value that matches both the spend category and the cost centre.
Please help
Thank you