Creating a search cell.

Hi all,

I had a quick browse and it doesn't seem like my specific issue has been covered from what I saw so here goes.

I want to create a search engine of sorts within my spreadsheet. I want that when I type in a keyword in that engine it would show me all the rows that contain that keyword while hiding the rest.

If not I'd like the results to show at the top.

At this point I've used the box at the top left (where it shows the name of the cell) and through renaming the cells in my first column (all unique numbers) I've managed to jump to the row I wanted. I wanted to use the same process for the second column but that one is filled with names, some of which are identical and since a cell needs a unique name I cant use that.

I'm pretty new to excel but it does seem like just about anything is doable it's just a matter of knowing how.

Thanks for the help.

Mally34

Hi, welcome to the board

See if you can adapt this to your needs...

	A	B	C	D	E
1	Code	value		code	value
2	aa	1		aa	1
3	bb	0			6
4	cc	2			4
5	aa	6			10
6	bb	3
7	cc	7
8	aa	4
9	bb	9
10	cc	5
11	aa	10

E2=IFERROR(INDEX(B:B,SMALL(IF($A$2:$A$11=$D$2,ROW($A$2:$A$11)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.