Hello,
I'm trying to perform a 'search box' function in my excel workbook that will display multiple results if necessary.
I have a workbook with 27 pages in it, the first is a cover/title page of sorts and the others contain tables with text - each other page relating to a different letter of the alphabet and called 'A', 'B', 'C' etc. On each of these pages there is a table which has two columns: 'Acronym' and 'Description' - columns F and G respectively.
What I have so far is a search box on the title page where you type in the cell an 'acronym' that you want and then in the cell next to it the corresponding line of 'description' from the relevant table is shown.
Using an Index-Match function 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 it is "*"&R4&"*").
Currently however it only shows the first 'hit' that it gets and I would rather it matched multiple results and showed all of them beside the search box. From my understanding this can be done through an array, although I just receive a '#NUM' error.
Is this possible to be done?
Any help would be greatly appreciated.
Thanks.
I'm trying to perform a 'search box' function in my excel workbook that will display multiple results if necessary.
I have a workbook with 27 pages in it, the first is a cover/title page of sorts and the others contain tables with text - each other page relating to a different letter of the alphabet and called 'A', 'B', 'C' etc. On each of these pages there is a table which has two columns: 'Acronym' and 'Description' - columns F and G respectively.
What I have so far is a search box on the title page where you type in the cell an 'acronym' that you want and then in the cell next to it the corresponding line of 'description' from the relevant table is shown.
Using an Index-Match function 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 it is "*"&R4&"*").
Currently however it only shows the first 'hit' that it gets and I would rather it matched multiple results and showed all of them beside the search box. From my understanding this can be done through an array, although I just receive a '#NUM' error.
Is this possible to be done?
Any help would be greatly appreciated.
Thanks.
