V1.0

First Version of this function. I doubt there will be more, as there isn't much to do from here. It currently does NOT work across sheet tabs, meaning that your status table needs to be in the same tab and ABOVE the bottom row of the stock table to prevent splitting when new rows are automatically created.
Example Data Table

Example Stock Table

Conditional formatting to make the status more apparent:

Note: If you really want to have a table in a separate tab, you can make a new table and mirror the data with =(YOUR_SPREADSHEET_TAB)!(CELL) Ex: Sales!B2
This produces a result like this:

You will need to redo the conditional formatting also.
Code: https://github.com/mcGLITCHGUITAR/Google-Sheets-Get-Status/blob/main/Function
P.S. I know you can download it, but it isn't worth downloading.