Forum Discussion
Tool to check table against 2 other tables in excel
Hi all,
I am working on project that checks on stock levels when next daya delivery list is copied in.
Company has a SQL server that has all stock information. I have pulled data into excel so now I have a table (Stock list) that contains stock id and quantity how many is in the storage.
User would daily have a list of new stock items that will be delivered next day. I need to check it against Stock list and display quality in the storage.
Stock list table contains more than 400000 rows.
You can use a formula like =ISERROR(B2) where B is your new column for quantities. Set a formatting style (like a fill color) to highlight cells where the formula returns TRUE.
Occasionally, there might be service interruptions with the Microsoft service that provides the stock data. You can check the Microsoft Office support page or forums to see if others are experiencing similar issues.
