Hi there, I'm hoping someone with far more knowledge than I can help with this query.
We've got a massive workbook which pulls all of the data out of a master data sheet, and splits it up according to the department the colleagues are in. In the example, it shows L&D and Customer Support in the tabs, but the full sheet with have many more in the list.
In the individual sheets, the calibrating manager will enter a reviewed score in columns I and J. In order to help another department by collating the results back into the Raw sheet, I'm trying to call back based on the User ID, which then Index/Matches the results in Raw!I and J, but I haven't got the faintest where to start.
I'm sure it's something within INDIRECT, but it's not something I've had much experience with. Is there any way of being able to search the entire workbook for the User ID to match the row without renaming the Department to be the same as the tab name?
Any help would be greatly appreciated.
Bookmarks