Forum Discussion
tpiet
Apr 20, 2020Copper Contributor
Using a Cell Reference In Place of a Text String
I'm trying to create a table with a column that answers the question "Is this item seasonally available." I'm using a search formula =IFERROR(IF(SEARCH("*April*",[@Months],1),"Yes"),"No"). But I woul...
Zack Barresse
Apr 20, 2020Iron Contributor
You can probably use...
SEARCH("*"&MonthCellReference&"*",[@Months],1)
SEARCH("*"&MonthCellReference&"*",[@Months],1)