98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Medium Priority · Version 365
Tue 13 Sep 2022, 15:39Delegate Emily said...
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?
Wed 14 Sep 2022, 09:27Trainer Marius said...
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
Wed 21 Sep 2022: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting BlanksSome times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted. |
