I have created a attendance module in the Google Sheets where i have one problem to present the data from one sheet to another. Currnetly i am using the INDEX
MATCH
function which is not working accurately.
I want to populate the Data according to each date and whenever the months changes then data should be change accordinly.
I have multiple employees which Leaves
are of different types i want them to populate for the whole month.
=ArrayFormula(XLOOKUP(1,(D$7>=Leaves!$D:$D)*($AJ$6<=Leaves!$E:$E)*(Leaves!$B:$B=$C8),Leaves!$I:$I,""
))
I have attached a google sheets which may explain better what i want to achieve. Your help will be much appreciated.