Hi all,
Wondering if someone can help me.
I'm trying to combine multiple iferror statements with multiple index matches and I'm not getting the results I'm after. I've attached an example spreadsheet which shows the formula I'm currently trying. The results on line 3 in the 1st tab in green are the correct results I am expecting, but the results in red underneath are what I'm hoping to see...but am not.
[Context to this - we go to multiple sites which are recorded by "site number" and record how many minutes were spent at each meeting. (There is a formula in the "raw data" tab in column D + E which sort out the order of the dates, creates a reference, which is then used in the formula in the "report" tab to order the data).
However, a site number could change, yet we still need the data for the old site number to sit alongside the new site number (hopefully the example explains this a bit better).
This could happen across multiple sites, but for simplicity I've just added in data for 1 site which has changed its site number. ]
I don't know if its just a simple fix in the way I'm trying to do the formula (I have tried googling this already but with no luck) or my approach is just wrong.
Any help / advise would be great.
Thanks !
Bookmarks