Previous Topic Next Topic

Matching Names to Id Numbers

Closed
Kelley M Likes - May 25, 2017 at 01:26 PM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 - May 25, 2017 at 02:25 PM
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
Related:

1 reply

Answer 1 / 1
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 146
May 25, 2017 at 02:25 PM
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
0