- There are three tabs in the sheet - Tab 1, Tab 2, and Tab 3.
- Both Tab 1 and Tab 2 have three columns - column a for Company, column b for Receipt, and column c for Date.
- For column a, there will be two data inputs - “LS” and “CMS”.
- I need to compile all the records from Tab 1 and Tab 2 where column a is “LS” in Tab 3
Tried using Query and Filter formula, but it says formula is not supported, any alternatives on it?