I've been looking for an answer to this but haven't found it yet, so I apologize if this exists somewhere already.
I'm trying to make a database of multiple workgroups (1 per tab) and have a combined tab that copies all of the information (based on the individuals name) over. The formula I have right now is below but it will only look at one tab and I need it to look at all tabs except the combined tab. Any help would be much appreciated.
=IF(ISBLANK($B6),"",INDEX(Sheet2!$C:$C,MATCH($B6,Sheet2!$B:$B,))) - this in in cell c6 on sheet1
So right now I have it looking at sheet1, b6 and finding a match in column b on sheet2, then inserting the data from cell c on the corresponding row into cell c6 on sheet1.
What I'd like to do is have it look at column b on sheet2 through sheet10 and return the information when it finds a match.
I hope I explained this properly...
I'm trying to make a database of multiple workgroups (1 per tab) and have a combined tab that copies all of the information (based on the individuals name) over. The formula I have right now is below but it will only look at one tab and I need it to look at all tabs except the combined tab. Any help would be much appreciated.
=IF(ISBLANK($B6),"",INDEX(Sheet2!$C:$C,MATCH($B6,Sheet2!$B:$B,))) - this in in cell c6 on sheet1
So right now I have it looking at sheet1, b6 and finding a match in column b on sheet2, then inserting the data from cell c on the corresponding row into cell c6 on sheet1.
What I'd like to do is have it look at column b on sheet2 through sheet10 and return the information when it finds a match.
I hope I explained this properly...
