Search and Display

Good Day,

I need some help, I am handling a records of students and I want to create a search and display form that would help me to lessen my work, I am using pivot table to get the summary but I want to try to have a template that would display a selected data,

I want to have a search box (cell) that if you would type a data as a keyword, multiple or selected data associated to the keyword that I entered on the search box (cell) will display below.

I know it is very simple to all experts here :D

To explain more here is my example.

ex.

I have 50 students divided into 5 different class (class 1-5 as class name)
I have a data of their Name,Address,Telephone No.,Email Add.,Mobile No.
I want to have a search box which if I entered a class name, their data will return or display below. If I type "Class 1" all students in that class will display below (i want to select only what data would display)

Many thanks and hopefully someone could help me.

Hello,

Thanks for your reply, I cannot attach the file

Thanks Sir and Ma'am

Here is my sample.

Thank you very much!

Thanks to all of you. God bless :D
Hopefully I can ask you again if I'm in trouble hehe

Good Day again,

Last one thing, is it possible to search different category on the search box then display its corresponding data? for example i will search by age or location or any of my category on my database, instead of making more sheets by having a search box per category i want to have a one sheet that can search different category.

Thanks again

See attached based on Glenn's reply:

Created named range "Category" (column P) which is used in the Data Validation in G1

Select from G1 then Criteria value in H1 e.g. Age / 10

Sorry if I did not explain it clearly.

I want to have a 1 search box that can accept any of my category. Here is my Column/Field name

Ex.

Class
Name
Agency
Region
Age
Gender

Then I have 1 search box that can search by those field names, if I search by Gender (Male), all males would be display. The one that you (Sir Glenn) did was good to search only by class (that's because of my first question i think)

But I think the file attached by Sir John was closer to what I'm thinking hehe :D

Thanks

Can you please post file showing expected output for your last search requirement.

I used your file Sir Glenn,

That's amazing and help me alot, I am working on it and just thinking how to be creative on it I attached my last file here hope you understand it clearly :D

Thanks Sir Glenn and Sir John

Try this ...

=IFERROR(INDEX(A:A,SMALL(IF($L$2=$A$3:$G$13,ROW($A$3:$G$13)),ROWS(I$3:I3))),"")

Enter with C+S+E