Index Match with multiple conditions

Agnieszka · #1 12-11-2023, 12:38 AM

Hi everyone,
Could you help me with attached spreadsheet?
On the left there is table with employees and leave they have approved.

On the right, I need to make a visual representation of it. I would like for the code from Column F to appear in Cell J2 if Employee with EID 1 (search must be by EID) was on leave 11 Dec 23.
I think this can be done with Index Match but I'm not able to do it myself.
I have manually entered first line for as an example of outocme.
Thank you for your time

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple match values for INDEX(MATCH) formula	jn82740	Excel	1	06-24-2023 11:48 PM
Excel Index and Match function with multiple criteria not searching the next record	mushtaqkadar	Excel	3	06-17-2017 12:20 AM
UDF multiple IFs INDEX-MATCH	grexcelman	Excel Programming	0	02-22-2015 04:20 PM
Help with multiple match and index formula	ryanwood	Excel	1	09-12-2012 07:53 AM
Vlookup or Index/Match - Multiple Criteria	ruci1225	Excel	1	01-15-2012 07:31 AM