Hyperlink table reference for email address showing wrong address

Copper Contributor

Hi!

I have a table (CCAL_Membership) on one tab. In another tab (Print Copy) I have a column that references the email column of the CCAL_Membership table. In the Print Copy table it is showing the right email address as pulled from the CCAL_Membership table. The Hyperlink, however, is returning an entirely different email address. I can't figure out why or how to fix it.  

 

Help please??

 

Photo and copy of the full spreadsheet attached.

 

Thank you for any help!

 

Barbara

 

1 Reply
You can use:
=HYPERLINK("mailto:"&EmailAddress,FriendlyName)