What would be the function/formula to automatically move data from one sheet to another AS LONG AS certain criterias are met?
In my case:
I have one "Master" sheet and 3 other sheets. I would like to get the data from the other sheets columns "G" and "H" IF column "L" has the same number as in the "Master" sheet.
Annotation 2020-01-14 151457.png
So basically if any of the other sheets has the same value in column "L" as the "Master" sheet in column "L" --> Copy the data from the same rows columns "G" and "H" to the "Master" sheets row, where the value in column "L" matches the value of column "L" in Sheet2, Sheet3 or Sheet4.
I hope I wasn't too unclear with this :D