FORMULA TO NOTIFY OF STOCK CHANGE

%3CLINGO-SUB%20id%3D%22lingo-sub-3010384%22%20slang%3D%22en-US%22%3EFORMULA%20TO%20NOTIFY%20OF%20STOCK%20CHANGE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3010384%22%20slang%3D%22en-US%22%3E%3CP%3EI%20upload%20a%20stock%20list%20from%20supplier%20every%20day%2C%20each%20one%20is%20added%20to%20a%20new%20sheet%20tab.%20I%20want%20to%20notified%20of%20when%20the%20stock%20values%20change%2C%20so%20need%20a%20formula%20to%20notify%20me%20if%20the%20value%20of%20cell%20in%20column%20G%20changes.%20As%20scrolling%20through%2050%2C000%20entries%20is%20extremely%20time%20consuming.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20makes%20sense.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3010384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3010571%22%20slang%3D%22en-US%22%3ERe%3A%20FORMULA%20TO%20NOTIFY%20OF%20STOCK%20CHANGE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3010571%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231131%22%20target%3D%22_blank%22%3E%40modeluniverse%3C%2FA%3E%26nbsp%3BUse%20VLOOKUP%20(or%20XLOOKUP%20if%20your%20Excel%20version%20supports%20it).%20See%20attached.%20TRUE%20means%20there%20was%20a%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I upload a stock list from supplier every day, each one is added to a new sheet tab. I want to notified of when the stock values change, so need a formula to notify me if the value of cell in column G changes. As scrolling through 50,000 entries is extremely time consuming.

 

Hope this makes sense.

2 Replies

@modeluniverse Use VLOOKUP (or XLOOKUP if your Excel version supports it). See attached. TRUE means there was a change.

 

@Riny_van_Eekelen Thank you!!