Forum Discussion
Solved
Apply New Column Based On Dates
Hello everyone, I've been working on an excel file for a while now and am stuck so any help would be super appreciated. Basically my problem is that I have two sheets, one with 3 columns, one for nam...
=IFERROR(INDEX(Sheet1!$B$2:$B$16,LARGE(IF((B2=Sheet1!$A$2:$A$16)*(Sheet2!A2>=Sheet1!$D$2:$D$16),ROW(Sheet1!$B$2:$B$16)-1),1)),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=TAKE(FILTER(Tabelle1[Office],(Tabelle1[Name]=B2)*(Tabelle1[Date]<=A2),""),-1)