Hi -
In my spreadsheet, I'm trying to create a search box in cell E5 - that searches cells B10-B242 (the data in my table). The data is a set of unique names.
Ideally I want the user to type the name they are looking for in the search box, and then receive back in another box the cell number if the name exists in the database. If it doesn't I want it to say "not found". For names that it did find , i'd also like that name to be highlighted in its cell.
does that make sense? can anyone help?
In my spreadsheet, I'm trying to create a search box in cell E5 - that searches cells B10-B242 (the data in my table). The data is a set of unique names.
Ideally I want the user to type the name they are looking for in the search box, and then receive back in another box the cell number if the name exists in the database. If it doesn't I want it to say "not found". For names that it did find , i'd also like that name to be highlighted in its cell.
does that make sense? can anyone help?