excel 2010
I have this formula:
=IFERROR(IF(VLOOKUP(H$3,'Customer Info'!G$2:AZ$1494,8,FALSE)=0,"",VLOOKUP(H$3,'Customer Info'!G$2:AZ$1494,8,FALSE)),"")
Which returns a persons email address stored in a database. Works great. I want to be able to click on that email address and send mail so I did this:
=HYPERLINK("mailto:"&IFERROR(IF(VLOOKUP(H$3,'Customer Info'!G$2:AZ$1494,8,FALSE)=0,"",VLOOKUP(H$3,'Customer Info'!G$2:AZ$1494,8,FALSE)),"")&"?"
All I did was add =HYPERLINK("mailto:"& to the beginning and &"?" at the end. It works fine. The problem I'm having is with the original formula it displayed the email address.
The new formula displays a hyperlink with the name "link". I want the hyperlink to display the actual email address.
Any suggestions
I have this formula:
=IFERROR(IF(VLOOKUP(H$3,'Customer Info'!G$2:AZ$1494,8,FALSE)=0,"",VLOOKUP(H$3,'Customer Info'!G$2:AZ$1494,8,FALSE)),"")
Which returns a persons email address stored in a database. Works great. I want to be able to click on that email address and send mail so I did this:
=HYPERLINK("mailto:"&IFERROR(IF(VLOOKUP(H$3,'Customer Info'!G$2:AZ$1494,8,FALSE)=0,"",VLOOKUP(H$3,'Customer Info'!G$2:AZ$1494,8,FALSE)),"")&"?"
All I did was add =HYPERLINK("mailto:"& to the beginning and &"?" at the end. It works fine. The problem I'm having is with the original formula it displayed the email address.
The new formula displays a hyperlink with the name "link". I want the hyperlink to display the actual email address.
Any suggestions