SOLVED

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)
Solution

@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.
1 best response

Accepted Solutions
best response confirmed by Excel (Iron Contributor)
Solution

@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

View solution in original post