Hello Excel Community,
I have been looking through the threads that have touched on this same topic and working on applying it to my example and I'm just not connecting the dots. I have my INDEX & MATCH function working but only returns the first value it finds and I need it to return all values across the row. Looking at this thread returns the values in a column by inputting in a single number. I have been playing with the formula provided in that thread and changed the column and row but I have not been successful at getting this to work. I was also looking at this thread using the aggregate function since I cannot use VBA. I have attached sample data with reduced amount of columns to show what I am looking for; in sheet 'B' column C shows my index and match formula and the subsequent rows show what else it should pull.
Thank you for your help!
Bookmarks