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.
I've tried copying that and it hasn't worked on my file even with ctrl+shift+enter but I can see that it works on the file you uploaded so its obviously something on my end, I'll keep fiddling to try and get it to work, but I really appreciate the help!
Do you work with the same Date format in Sheet1 and Sheet2 in your file? In the sample it works if i use e.g. 25.05.2022 in both sheets or if i use e.g. 50522 in both sheets. Otherwise the formula can't compare the dates.
- I just fixed the dates and it worked like a charm, thanks again!