Share via

Match employee names to employee ID

Anonymous
2016-02-17T16:49:26+00:00

I have 159 employees and we have assigned each employe an EmployeeId.

So I have a worksheet that has 2 columns. Column A is the new EmployeeID and column B is the employee name. I have second worksheet that has just over 23,000 rows. Each employee has hundreds of rows.

What I need to do is come up with some sort of formula that I can put in column A of worksheet 2 (the one with the 23,000+ rows) that will look at column B of worksheet 2 (this column contains the employee names) then find the matching name in column B of worksheet 1 and return the correct EmployeeID from column A.

Not sure if this is possible but if so would be an incredible time saver.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Vijay A. Verma 104.8K Reputation points Volunteer Moderator
2016-02-17T17:34:11+00:00

Put following in A2 of second sheet and drag down -

=IFERROR(INDEX(Sheet1!A:A,MATCH(B2,Sheet1!B:B,0)),"")

Was this answer helpful?

4 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-02-17T17:45:15+00:00

    Thank you so much. What a time saver

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments