vlookup / hyperlink to e-mail

[PEAKCAB]

Hello,

Please could any help on a vlookup issue? i have the following lookup

=HYPERLINK(IF(IFERROR(VLOOKUP($C$29,Supplier,11,FALSE),"")=0,"",IFERROR(VLOOKUP($C$29,Supplier,11,FALSE),"")))

I have a invoice and when i populate the suppliers details i would like to have a hyperlink to their e-mail address. When i apply the above i get the error message "cannot open selected file"

thanks

Rich

 

[FormR]

Hi, if I understand correctly and your VLOOKUP() returns an email address, you could try:

=IFERROR(HYPERLINK("mailto:"&VLOOKUP($C$29,supplier,11,FALSE),VLOOKUP($C$29,supplier,11,FALSE)),"")

 

[PEAKCAB]

Thanks FormR, works brilliantly