excel multiple tasking

New Contributor

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

@MarcJur 

=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?

@MarcJur 

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

That really works perfectly, thanks very much
Thank you Juliano for your help, it works