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 also multiple data for one name (but not on the same date). All data should be in one line for a name on a given date (all year round). The schedule is given below, but this is only a fraction, in fact there are many times more. I would be vera just needed to know the principle by which this could be done Please check the attachement.
4 Replies
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 🙂
=IFERROR(INDEX($A$16:$D$69,MATCH(1,($A2=$A$16:$A$69)*(C$1>=$B$16:$B$69)*(C$1<=$C$16:$C$69),0),4),"")
Is this what you want to do?
- That really works perfectly, thanks very much
