Hi there
I've been trying to figure this out but was going nowhere.
I have an excel sheet containing multiple sheets of data.
The sheets contain Rows of data labelled as ID, TYPE and STATUS. In my example attached, the datas are stored on Sheet2, Sheet3 and Sheet4
What I'm trying to do is enter a valid ID on Sheet1 as indicated in my example, then using INDEX and MATCH, to display the TYPE and STATUS corresponding
to that ID.
The problem I face here is that I am successful in displaying data only from Sheet2. I'm not sure how I can display data from Sheet3 and Sheet4, assuming I enter an ID that belongs to these sheets.
Any help is much appreciated.
Bookmarks