Short version: Looking to use a "searchbox", or just a cell for entry to search a second sheet(In the same workbook) and only pull rows that contain the partial match of the "searchbox" cell.
i.e.
Search.PNG
EDIT: Going to be a bit more explanative I think.
Currently in my Sheet 1 in cell D8, I have this formula that references D7
for a search option as follows:
Capture46.PNG
However when I drag and copy the row down, I get this error:
Capture47.PNG
The end goals is the first image, including the nearby rows all in the same table, so Sheet2!Range A:C technically. Only searching in Column A.
There are about 25,000 entries as well, as a note.
Is there a way I can copy this down further, or a better way in general?
Thank you
Bookmarks