How to find the data by entering the data in one cell

[Closed]
Report
Posts
2
Registration date
Friday March 8, 2013
Status
Member
Last seen
March 9, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Hello,

we are dealing with projects of different colleges. there is a data of more than 1000 students. each time i have to click on the respective sheet of the college and i have to search through the name or student ids whenever i have to edit the data of the students. i want put one cell in the sheet1 (Like "enter the hall ticket number" box in the websites to get the results) which can accept a student id or a cell name which take me to that respective student id or cell name when i enter the id and hit enter. please help in in this regards.



1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
45
Hi aparnaveeravalli,

You can use Microsoft Excel's Vlookup function to populate the list by entering the unique "hall ticket number". For more details please check the below mentioned link:

https://ccm.net/faq/12503-how-to-use-the-vlookup-function-on-excel

Please revert for clarification.