Add Data only where applicable

[spreadshearer]

I have two spreadsheets. Both have a column of student IDs. On one of the spreadsheets, each student ID has it's respective completed grade count. I need those grade counts to populate into a blank column on the other spreadsheet, matched to their respective student ID. Not all student IDs in the second spreadsheet have completed grade counts (either they never registered, dropped or have yet to complete the course).

How can I do this? Thank you so very much for your help!

Kindly,

Michael

 

[SteveO59L]

Try vlookup()

 

[spreadshearer]

solved, thank you!

vlookup worked like a champ, though it was much simplier than I thought (for this instance). This will actually help for a whole bunch of stuff I am doing on this report, so thanks ahead of time!