Dec 10 2021 09:47 AM
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.
Dec 10 2021 10:33 AM
=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?
Dec 10 2021 10:36 AM
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