Combine If and Hyperlink formulas?

[gk141054]

Hi everyone,

I have a hyperlink to setup an e-mail in a column of a table as follows:

=HYPERLINK("mailto:joebloggs@gmail.com?subject=This is an e-mail subject&body=This is the e-mail body,"Click here to e-mail Joe Bloggs")

That works fine, but the challenge is I only want the hyperlink above to show if the text in column D of the same row contains a wildcard match for certain letters, say ABC.

Can anyone guide me on the best way to do this please? Presumably an IF function but i'm not sure how to combine the two, so if anyone can answer that or suggest other options please.

Thanks in advance for all advice offered.

 

[Scott Huish]

=IF(ISNUMBER(SEARCH("ABC",D2)),HYPERLINK("mailto:joebloggs@gmail.com?subject=This is an e-mail subject&body=This is the e-mail body","Click here to e-mail Joe Bloggs"),"")

If you want it to be case-sensitive use FIND instead of SEARCH