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
