Help With A function To Pull Quantity

Hi All,

I need help with the attached. The section highlighted in blue is a report that i pull off of our system and the part highlighted in Green is a stock list that i need to create per location.

So i need H2 to have a vlookup to bring back the value in D2 and I2 to return the value in D5. However i need to put in a function that looks at the plant Column C and if it is CT01 it places the available under CT Column H. I hope this makes sense.

Thank you in advance

In the attached 3 solutions:
1. On Sheet1 at cell L1 there's a table that can be right-clicked and Refreshed (Power Query/Get & Transform Data)
2. On Sheet1 (2) at cells H2:J2, 3 (very similar) formulas which can be copied down.
3. Also on Sheet1 (2) at cell L1 is a standard pivot table.

Wow thank you very much for the help, much appreciated, i will play around with both, the list i pull is over 12 000 line items and items are added and removed on a regular basis, trying to make it as bullet proof as possible. This will help a lot thanks again.

Here is the formula solution.
In F2 and copied down

In G2 and copied down

In H2 and copied down and across