Matching Names to Id Numbers

Closed

Kelley M Likes - May 25, 2017 at 01:26 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 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

We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history.
Orkut login - Guide
How to delete whatsapp account without login - Guide
Gmail login another account - Guide
Hi5 login old account - Guide
You need the official whatsapp to use this account ✓ - WhatsApp Forum

1 response

Answer 1 / 1

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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

Similar discussions

Facebook says that my email doesn't match my facebook email

i can't enter to my account facebook

Yahoo account reactivation

someone hacked my fb account and changed my password

Couldn't find your Google account

Similar discussions

Subscribe To Our Newsletter!