Share
ReportHi all,
I am having troubles building a function that is supposed to do a couple of things at once:
I have 2 data sources (Excel), table1 (parts needed per piece) and table2 (total inventory). table2 contains all data (and more) that is stored in table1.
What I want to achieve OnSelect of a button:
The function should compare both tables, but only 2 of many columns (name & product). For the resulting row matches for both in table2, a calculation should be performed: substract from the numerical value "inventory" the amount which is stored in the "parts needed per piece" field in table1, of course this should be done for all found matches at once.
I tried multiple versions with if/lookup/patch, but all weren't successful.
Looking desperately for some help!
Greetings
Christoph
All responses (
Answers (
335
