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

Re: excel multiple tasking

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

Re: excel multiple tasking

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

Re: excel multiple tasking

That really works perfectly, thanks very much

Re: excel multiple tasking

Thank you Juliano for your help, it works