Hi,
I have sheets, all formatted identically and all have the same table with all columns and rows labelled the same.
I then have a summary sheet set out as below:
Sheet 1 Sheet 2 Sheet 3 Sheet 4 Sheet 5
Item 1
Item 2
Item 3
Item 4
Item 5
I'd like the formula to reference the column (sheet) and the row (item) and return the result but I'm struggling accomplishing it with more than 2 sheets
This is what I have..
Any help would be appreciated.Please Login or Register to view this content.
Bookmarks