Using a Cell Reference In Place of a Text String

Copper Contributor

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 would prefer that the "*April*" be replaced with a cell reference to a cell that contains the Current month. That way, when it goes from April to May, the search function will return different results.

 
 

 

2 Replies
You can probably use...

SEARCH("*"&MonthCellReference&"*",[@Months],1)

@tpiet 

As a comment, you don't need to add asterisks using SEARCH. To compare

=IF(ISNUMBER(SEARCH("April",[@Months])),"Yes","No")
and
=IF(COUNTIF([@Months],"*April*"),"Yes","No")

return the same.

If month name is in cell A1 that will be like

=IF(ISNUMBER(SEARCH($A$1,[@Months])),"Yes","No")
and
=IF(COUNTIF([@Months],"*" & $A$1 & "*"),"Yes","No")