Forum Discussion
If, Index & Match formula help required
I have a spreadsheet with 3 tabs, "Scorecard" used to pull in data from the other two tabs "Raw Data Tod" and "Raw Data Jim". I have two formuals as per below that work independently of each othe...
Hi Steven, If you have Excel 2016 or are able to add Power Query in a older version the best option may be to create queries for the data in both tabs and merge them together with an added key column in each to indicate Tod or Jim. You could then add the merged query to a new data sheet as a table and point your formulas there or if you wanted to get a bit more advanced you could add it to a data model in power pivot.