What formula do you use to search and then have it go to the cell the info you are

imfromNJ

New member
looking up is in? I'm using Office 2007 (excel) and have a 1524 cells referenced to a corresponding name and number. Is there a way to type a formula in a cell to search the library and then send me directly to the cell that the name i'm looking for is at. Example: looking for student's last name and want to type it in so it will take me to their info. Much like in a GPS start typing the street or city and it narrows it down to what you typed in. please and thanks for the help!
 
Back
Top