Forum Discussion
MarcJur
Dec 10, 2021Copper Contributor
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...
OliverScheurich
Dec 10, 2021Gold Contributor
=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?
- MarcJurDec 13, 2021Copper ContributorThat really works perfectly, thanks very much