Matching Names to Id Numbers [Closed]

Report
-
Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
-
Hi,
I have a list of 1,200 students.

They have won awards. I want to match the students who won awards with their student id numbers. Is there a way to do this?

I have Column A Student ID Column B Student Name on sheet 1

Sheet two is Column A Student Name Column B Award Column C is where I want the ID to appear.

Thoughts?
Thanks!
Kelley M Likes

1 reply

Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
Kelley M Likes, Good afternoon.

Try to use:

Sheet2
C1 --> =INDEX(Sheet1!A1:A1200,MATCH(A1,Sheet1!B1:B1200,0))

Adapt range to your reality.

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão