Forum Discussion
MattSmith1375
Apr 09, 2024Copper Contributor
Formula not working - Return value in cell if another cell contains text from a list
I am trying to get a formula that would evaluate the cells in the column 'data' to see if they contain any of the words contained in the column 'List', then if true return the word "Groceries" or oth...
- Apr 09, 2024
Your formula works in my Excel 2013 when it's entered as an arrayformula with ctrl+shift+enter. If we don't work with Office 365 or Excel for the web we have to enter arrayformulas with ctrl+shift+enter.
OliverScheurich
Apr 09, 2024Gold Contributor
Your formula works in my Excel 2013 when it's entered as an arrayformula with ctrl+shift+enter. If we don't work with Office 365 or Excel for the web we have to enter arrayformulas with ctrl+shift+enter.
- MattSmith1375Apr 10, 2024Copper ContributorIt worked! Thank you Oliver!