Emily has attended:
Excel Advanced course
Formulas
I am trying to link two spreadsheets together so I can confirm whether a student has or hasn’t completed. One spreadsheet (sheet 1) has the students name, email address and whether they have or haven’t completed. The other (sheet 2) has the students name cohort and email. I would like to add whether they have completed to the spreadsheet with the cohort details. Which formula should I be using?
RE: Formulas
Hello Emily,
Thank you for your question. As long as the student names appear in the same way in both sheets, I would suggest XLOOKUP (or VLOOKUP if you have Excel 2013, 2016 or 2019).
If Column A holds the name and Column D holds the completion status,
XLOOKUP would be:
=XLOOKUP(A2,OtherSheet!A:A,OtherSheet!D:D)
VLOOKUP would be:
=VLOOKUP(A2,OtherSheet!A:D,4,FALSE)
Because you have data in another sheet, you have to link to that sheet in your formula, as shown in my examples (OtherSheet).
I hope this helps.
Kind regards
Marius Barnard
STL
