SOLVED

Query related to Index with Match function

Super 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 Zain123 (Super Contributor)
Solution

@Zain123 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.