Query related to Index with Match function

Iron Contributor

Hello Everyone, 

I am trying INDEX with MATCH function. 

It's able to return the department and last name but not the building or email.

like -

Annotation 2022-07-08 104323.png


Please help..


Here is a attached file..


2 Replies
best response confirmed by Excel (Iron Contributor)

@Excel Change the headers in the small table to match the ones in the big table.

Screenshot 2022-07-08 at 09.31.43.png

I forget to see that..
Thank you so much sir.