FIND RECORDS

I have an excel spreadsheet with over 3000 names ranging from column a to al i am looking for the quickest way to find the employee id based on what is entered in cell a10. what is the quickest approach.i would like to be able to do it in formula or vba
SvgmassiveAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
Names in column A and search value in A10 will give a circular reference.
How are the names and ID arranged.

Could you upload a sample showing the structure.
0
 
SvgmassiveAuthor Commented:
i am using the find method to search,i will upload a structure later
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.