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

Closed
aparnaveeravalli
Posts
2
Registration date
Friday March 8, 2013
Status
Member
Last seen
March 9, 2013
- Mar 8, 2013 at 06:17 AM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
- Mar 8, 2013 at 04:20 PM
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

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 8, 2013 at 04:20 PM
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.
0