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!
Yes! You just need to adjust your formula to check if the word "Discover" appears anywhere within the cell in Column C, rather than matching it exactly.
✅ Updated Formula (with ISNUMBER(SEARCH(...)) for partial match):
=INDEX('My ✓ing'!E:E, MATCH(1, (MONTH('My ✓ing'!B:B)=1) * ISNUMBER(SEARCH("Discover", 'My ✓ing'!C:C)), 0))
🔧 Why it works:
- SEARCH("Discover", 'My ✓ing'!C:C) looks for the word "Discover" anywhere in the text.
- ISNUMBER(...) turns that into TRUE/FALSE depending on whether it's found.
- The rest of your formula stays the same to filter by January dates in column B.
⚠️ Important:
Because this is an array formula, you may need to:
- Press Ctrl + Shift + Enter if you're on Excel 2019 or earlier.
- On Excel 365 or Excel for the web, it should work as-is.
Let me know if you want it to return multiple results instead of just the first one!