I can index and match across 2 sheets easily enough, but how can I index multiple sheets and match across those multiple sheets as well?
=IFERROR(INDEX(Defense!A:A,MATCH(RB!C2,Defense!B:B,0)),0)
I need to index Y on sheet 2,3,4,5 and then match B on 2,3,4,5 to B on sheet 1 which will paste in K on sheet 1.
I have tried various combinations of just adding index and match statements, but it fails.
The above formula is what I have tried to expand, because it works great with just 2 sheets.
Bookmarks