Hi i use index match formulas all the time, they work great. However since updating my version of excel I now get a Spill error when trying to use the index match function.
Can anyone help with this formula that was previously working but now produces this error?
=INDEX('[RHS Snapshot 03.01.2020.xlsx]Live Sites'!$E:$E, MATCH(E:E,'[RHS Snapshot 03.01.2020.xlsx]Live Sites'!$B:$B,0))
Kind Regards
Danny
Bookmarks