I have a vlookup formula that creates an email and fills in the email address that can vary. I now want to add a subject to the email but the subject varies and also I don't want the subject to be shown as part of the vlookup result.
this is the vlookup formula I have, how do I add the subject to the email from sheet1 cell A3
=HYPERLINK(CONCATENATE("mailto:",VLOOKUP(H16,'1141 lookup'!AA:AF,5,0)),VLOOKUP(H16,'1141 lookup'!AA:AF,5,0))
thank you in advance
smiler44
this is the vlookup formula I have, how do I add the subject to the email from sheet1 cell A3
=HYPERLINK(CONCATENATE("mailto:",VLOOKUP(H16,'1141 lookup'!AA:AF,5,0)),VLOOKUP(H16,'1141 lookup'!AA:AF,5,0))
thank you in advance
smiler44