B$7$

A

Using XLOOKUP FORMULA, Find the Students where Instructor is "James", Date is $"1-$Mar", and Department is "English" $(20$ pts$)$

E

F

G

H

$1$

K

L

Students

$\backslash$table$[[$Date$,$Instructor,Department,Students$],[1-$Feb,James,English,$35],[2-$Feb,James,Maths,$42],[3-$Feb,James,Science,$37],[4-$Feb,Robert,Maths,$15],[1-$Feb,Robert,Chemistry,$29],[1-$Apr,Robert,Science,$18],[1-$Feb,Robert,English,$39],[1-$Mar,James,English,$34],[5-$Feb,James,Maths,$49],[3-$Feb,Robert,Physics,$17],[3-$Feb,Robert,Science,$16]]$