In Assessments sheet, use VLOOKUP to get all students names that match their IDs. Students name are available in "Students Details" sheet. What is your formula in cell B15?

Question

Answer

=VLOOKUP(A15,'Students Details'!A1:B36,2,FALSE)

Answer

=VLOOKUP(A15,'Students Details'!$A$1:$B$36,2)

Answer

=VLOOKUP(A15,'Students Details'!$A$1:$B$36,1,FALSE)

Answer

=VLOOKUP(A15,'Students Details'!$A$1:$B$36,2,FALSE)

Crowdly

In Assessments sheet, use VLOOKUP to get all students names that match their IDs...

Want instant access to all verified answers on moodle.polytechnic.bh?