Search Report Using Vlookup & Data Validation
Data Sheet
You can Make Report By Required Criteria.
In the below Image sort Class wise Student list from main Student List .
For Making the Sheet Pick your Data File
Insert Blank Column Before Starting List column.
And Make Blank Report Format.
On the top Make Criteria Cell.
Here We are find Particular class student.
Data Validation
Drop Down List
For Class drop down list go to Data tab > Data Validation
In setting tab Select Validation criteria list
Type in the source field. Here Criteria is Each Class. Type Class including Comma.
Then Click OK
Class drop down list will Enable.
Click cell A4. Apply IF formula .
=IF(E4=$J$2,A3+1,A3)
You must have J2 Cell Lock by pressing F4.
Copy Cell A4 and Paste till to end your data.
You can paste in extra cells for future Data Report.
IFERROR
In the Blank format Apply Vlookup with IFERROR.
Here Lookup Value is Sr. No. Cell.Range Select from column A to E . If error Formula will help for #VALUE! convert in Blank Cell.
Copy Formula & paste below.
You will get Selected Class Student List.
