View Single Post
  #5   Report Post  
youth
 
Posts: n/a
Default vlookup and email addresses

peo,
I tried this formula instead:

=HYPERLINK("mailto:
"&VLOOKUP($B17,replist!$A2:$E25,COLUMNS($A$1:E1),F ALSE))

It works but unfortunately I see the words: "mailto"
before the email addresses, how do I not let this show?