Hello everyone,
So I have a pretty lengthy list of merged data from multiple workbooks where most of the data I need is now in one column.
One of the issues I'm having is reiterating a search in a column(B).
I want to search for every occurrence of the word "Item" and then pull the 9 text strings below that occurrence.
I tried using HLOOKUP but I receive an #N/A after selecting a blank column (G) for the array.
=HLOOKUP("Item", B:B, {1,2,3,4,5,6,7,8,9}, FALSE)
Eventually I'd like to pull data from left-to-right as well for other occurrences(Owner, Date, etc).
I feel like this is a case for Index Match but I can't seem to wrap my head around this specific scenario.
Any help would be appreciated!
Bookmarks