how do you look up a name in a worksheet

J

Joe

Hi there, I am currently working with alot of data in a excel spreadsheet,
roughly about 22,000 names and I want to know how you would look up a
particular name if for example you are at row 100 and you can't remember what
the row that name was in. So basically I want to know how to look up specific
names within an excel spreadsheet e.g mr joe bloggs in row 24 etc etc

Many thanks
 
K

Kevin B

You could select the column that contains the names, press Ctrl + F and use
find to locate a specific name.
 
J

jb_tenor1

Quickest way to do this is just to turn on the AutoFilter. Then, just click
the drop-down in that column to select the name. If you're looking to have
Excel return a row number value, that would be a little different.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Look Up Formula With Veried Search Range 2
How to break up a book's endnotes by chapter in a file containing a whole book? 0
Merging from an Excel file with graphics 1
Grouping Names in Mail Merge 0
Look up with multiple variables 1
Having Blank Cells, etc. ? 1
Name look up 3
How to sort a list with Mr, Mrs, Miss ? 5

Top