Forum Discussion
Solved
Help with formula
Hello! If I'm trying create a formula that pulls data from one sheet into another. I want it to pull in data in column E if column B has a january date AND column C has the word discover in it, into ...
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!
This post is marked as solved but I enclose the following to provide an indication of what is possible using Excel 365.