Hello,
I'm trying to perform a 'search box' function in my excel workbook.
I have a workbook with 27 pages in it, the first is a cover page of sorts and the others contain tables with tables with text - each other page relating to a different letter of the alphabet adn called 'A', 'B', 'C' etc.
What I have so far is a search box on the title page where you type in the cell and then in the cell next to it the corresponding line from the relevant table is shown.
I'm using an Index-Match formula to perform this task with the input cell being labelled as a 'wildcard' (if that makes sense? eg the input cell is R4 therefore in the formula is "*"&R4&"*").
What I would like to happen is that if the input text matches multiple criteria then all the relevant results are shown in a table beside the search box.
Is this possible to be done? I've tried an Index-Small fucntion but it kept giving a #NUM error.
Any help would be greatly appreciated.
Thanks.
I'm trying to perform a 'search box' function in my excel workbook.
I have a workbook with 27 pages in it, the first is a cover page of sorts and the others contain tables with tables with text - each other page relating to a different letter of the alphabet adn called 'A', 'B', 'C' etc.
What I have so far is a search box on the title page where you type in the cell and then in the cell next to it the corresponding line from the relevant table is shown.
I'm using an Index-Match formula to perform this task with the input cell being labelled as a 'wildcard' (if that makes sense? eg the input cell is R4 therefore in the formula is "*"&R4&"*").
What I would like to happen is that if the input text matches multiple criteria then all the relevant results are shown in a table beside the search box.
Is this possible to be done? I've tried an Index-Small fucntion but it kept giving a #NUM error.
Any help would be greatly appreciated.
Thanks.
