Forum Discussion
excel multiple tasking
Hi there, some days ago i received a demand to complete a task that made me a lot of wringles. The main task is to assign data (SC, O, P113, etc.) based on the names to each date. However, there are...
If I understood it correctly
=IFERROR(
INDEX($D$16:$D$69,MATCH(1,
($A$16:$A$69=$A2)*($B$16:$B$69>=C$1)*
($C$16:$C$69<=C$1),0),1),"")Find attachment
Thank you Juliano for your help, it works 🙂