Previous Topic Next Topic

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

Answer 1 / 1
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 67
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