Lookup students name and grade and return result

**Sheldon709** · 12-03-2018, 10:39 AM

Hello Everyone;
I am trying to format student grades for the end of the semester. In Column A I have 300 student names for a specific course, in column B I have their grade for a specific exercise, in column C I have a list of ~30 student names that I have to input marks online for. How can I get Excel to match up my required student names with the whole list and extract their specific and place this in column D? I am thinking it is done using the “Match” function, but not entirely sure. I used to do a lot of spreadsheet work about 15 yrs ago (Quattro Pro and Lotus) but haven’t done much since then;
Thanks
Sheldon

**jeffreybrown** · 12-03-2018, 10:46 AM

Hi Sheldon & Welcome to the Forum,

I believe you may need to look into a Vlookup!

Based on your description, maybe =VLOOKUP(C1,A:B,2,0)

**Richard Buttrey** · 12-03-2018, 10:53 AM

Hi and welcome to the forum

A normal Vlookup in D1 copied down should do. i.e.

Formula:

Please Login or Register  to view this content.

You might also like to consider a more elegant solution with a Pivot Table and a Slicer should you want to filter out specific students.

**Sheldon709** · 12-03-2018, 01:58 PM

Thanks everyone, I got it to work with the VLOOKUP function;
Sheldon

**jeffreybrown** · 12-03-2018, 02:01 PM

Good to hear Sheldon and you are welcome. We are happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**salehe** · 12-05-2018, 02:04 AM

Hi!
I need to create automatic individual student report from students results excel sheet . any idea?.

**AliGW** · 12-05-2018, 02:09 AM

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.