Referencing a cells contents within a wildcard within a formula

[JakeCardigan]

Hi all,

hoping you can shed some light on a problem I am struggling to work around.

=IF(COUNTIF(A13,"*f1*"),"BRANDED",IF(COUNTIF(A13,"*f2*"),"BRANDED LINK","NON BRANDED"))

However within the wildcards I want to look for the contents of cell F1 and cell F2... is this possible??

Any help would be gratefully received

Thanks

 

[Andrew Poulsom]

Welcome to MrExcel.

Like this?

=IF(COUNTIF(A13,"*"&F1&"*"),"BRANDED",IF(COUNTIF(A13,"*"&F2&"*"),"BRANDED LINK","NON BRANDED"))

 

[JakeCardigan]

Worked a treat, thanks so much