Jul 08 2022 12:27 AM
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 -
Please help..
Here is a attached file..
Jul 08 2022 12:32 AM - edited Jul 08 2022 12:33 AM
Solution@Excel Change the headers in the small table to match the ones in the big table.
Jul 08 2022 12:42 AM