martinsimart
New Member
- Joined
- Mar 23, 2018
- Messages
- 9
Good evening
I am using this code: =INDEX(a3:b100,MATCH(L9,a3:a100,0),MATCH(M8,a3:b3,0))
I have a drop down box in L9 listing names, when I choose a name it copies an email address from another (hidden) column
My question is this: the email addresses in the original hidden column are hyperlinks but when the formula takes them across to match the name chosen they lose their hyperlink status, can I do something to keep the hyperlink with underline?

Thanks
I am using this code: =INDEX(a3:b100,MATCH(L9,a3:a100,0),MATCH(M8,a3:b3,0))
I have a drop down box in L9 listing names, when I choose a name it copies an email address from another (hidden) column
My question is this: the email addresses in the original hidden column are hyperlinks but when the formula takes them across to match the name chosen they lose their hyperlink status, can I do something to keep the hyperlink with underline?

Thanks