Use of Index/Match functions for verifying Stock with Job needs

Hello Sir,

Herewith, attached is a file concerning stock and distribution to users according to their needs, while verifying the conditions on either side for the available balances on both sides.....
In Column C, required formula for the quantity to automatically refresh whenever a stock entry comes from outside sources, indicating the current total of the item since the start of the inventory, also in Column F, become automated when the item is issued to site needs, at the same time the stock could confirm the quantity left available for distribution....

In the site needs table, Column M gets automated whenever the requester enter a item and its required quantity as per needs, the qty gets summed and requester know whats is current total sum he is requesting for items needed to site, while referencing stock data and utilizing Index/match functions. Columns O, P, and Q are not retrieving the precise data from the stock data table; the necessary data to be shown is noted in the Site issue table highlighted in orange color.

Please assist me.

JD

Thank you, sir. The version has now been updated in the profile.....

Dear Sir,
Thank you for this excellent advice. Following the receipt of your previous message, I have been constantly working these days on Columns C, F, and M, seeking ways to automate these columns. However, your last message was brilliant and its picking the details as per the requirements, and now the requester can ably compare the stock he is seeking for from the stock area….

I think the formula would still select the correct reference if I raised the numbers in Column L, .i.e, to increase in site request quantities as the requester could simply increase the quantities in Column L instead of typing the same number repeatedly...!!

Also, when the site is requested, if the item is available in the yard, the DO appears in Column O, allowing the requester to see the stock item they are requesting without needing to check with the stockkeeper, and demand for the materials….

Thanks again sir
"SOLVED"