Hello,
I'm trying to search for a certain cell text, and bring the entire row containing that text from multiple sheets.
In each sheet, there are duplicate text values, so I need to bring all of them.
I made an example file where aa (in yellow highlight is what I'm looking for) is entered and the green highlight part is generated from sheet a and b.
I been looking at some example with vlookup and index, but I can't seem to find one that combines the duplicated value in the same sheet + multiple sheets.
Is there a certain thing I should be looking in to?
any reference or help is appreciated
Thank you!
Bookmarks