Good Afternoon,
Thanks in advance for any assistance provided.
I have a spreadsheet that I am using to track the vacation request of my employees for the year. One tab has the requested start and end dates and the second tab has the employees names and the dates filled out across the year. This is a multiple criteria formula where it looks for the employee, looks at the amount of days requests and looks at the type of vacation requested. I am using the following formula to return the data I need. Now to be clear the formula does work but makes the file take up to 15/20 minutes to load. Is there an easier way to get this data or a lighter formula (hopefully that makes sense) that can achieve the same result?
=IFERROR(INDEX(Requests2!$K:$K,MATCH(1,INDEX((Requests2!$F:$F=$B$8)*(Requests2!$C:$C>=L5)*(Requests2!$B:$B<=L5),0,1),0)),"")
Thanks in advance for any assistance provided.
I have a spreadsheet that I am using to track the vacation request of my employees for the year. One tab has the requested start and end dates and the second tab has the employees names and the dates filled out across the year. This is a multiple criteria formula where it looks for the employee, looks at the amount of days requests and looks at the type of vacation requested. I am using the following formula to return the data I need. Now to be clear the formula does work but makes the file take up to 15/20 minutes to load. Is there an easier way to get this data or a lighter formula (hopefully that makes sense) that can achieve the same result?
=IFERROR(INDEX(Requests2!$K:$K,MATCH(1,INDEX((Requests2!$F:$F=$B$8)*(Requests2!$C:$C>=L5)*(Requests2!$B:$B<=L5),0,1),0)),"")