I have a workbook with three worksheets. Two of the worksheets have data in exactly the same layout starting with a surname in column A. The third worksheet is a search page. I have already created a cell where I can enter the search criteria (a surname) and in the adjacent cell it returns the number of instances of that surname. I would also like it to return the whole row of each instance of that surname in a table. I have looked at INDEX/MATCH but can't workout how to automatically add another row to the results. I think this is possible?!
I have uploaded a file TEST.xlsx (I think!)
Any help would be much appreciated.
Geoff
Bookmarks