The question i have is probably simple but I can't seem to find it.

I started an excel spreadsheet of a list of college football players and the list is rather long to the point where it is taking me some time to search for names that i have already listed. So i wanted to start a function that allowed me to find a players last name within a spreadsheet. There are a list of Last Names that cover more than one column so I simplified it by naming a range of Columns that have these last names and calling it "Last_Names".

The issue that i am having is i want to a cell (for example cell A2) to have the function and the cell to the right of it (cell A3) to be the value im looking for.

Here is the issue: I want to be able to type in a players last name and have the function take me directly to the cell that contains that Name. I DONT want the function to return a value telling me there is 1 or 2 results. I DONT want that function to tell me there is a match and thats it.

Ideally i want to be able to type in a name and have excel take me to that name in the spreadsheet. If i could get that cell to highlight making it easier to spot with my eye that would be great.

Thoughts?