Forum Discussion
Help with formula
Thank you so much! That seems to be working!
=INDEX('My ✓ing'!E:E,MATCH(1,(MONTH('My ✓ing'!B:B)=1)*(ISNUMBER(SEARCH("Discover",'My ✓ing'!C:C))),0))
This is the formula that worked for what I was trying to do. I tried doing this but couldn't get it to work right, I think I was missing some () or something, again thank you so much for your help!
=INDEX('My ?ing'!E:E,MATCH(1,(MONTH('My ?ing'!B:B)=2)*(ISNUMBER(SEARCH("Discover",'My ?ing'!C:C))),0))This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone works with legacy Excel such as Excel 2013. In the attached file i've added the formula in cell C11 in order to check if it works.
=IFNA(IF(C$2="Paid",INDEX('My ?ing'!$E:$E,MATCH(1,(MONTH('My ?ing'!$B:$B)=MONTH(C$1))*(ISNUMBER(SEARCH($B3,'My ?ing'!$C:$C))),0)),
INDEX('My ?ing'!$B:$B,MATCH(1,(MONTH('My ?ing'!$B:$B)=MONTH(C$1))*(ISNUMBER(SEARCH($B3,'My ?ing'!$C:$C))),0))),"")In the attached file i've added a formula that pulls dates and amount from the "My ?ing" sheet. The formula is in cell C3 and dragged across range C3:F6. In range C1:F1 are dates 01.01.2025 and 01.02.2025 that are formatted as "januar" and "februar".
Thank you so much! That seems to be working!
=INDEX('My ✓ing'!E:E,MATCH(1,(MONTH('My ✓ing'!B:B)=1)*(ISNUMBER(SEARCH("Discover",'My ✓ing'!C:C))),0))
This is the formula that worked for what I was trying to do. I tried doing this but couldn't get it to work right, I think I was missing some () or something, again thank you so much for your help!