index match losing hyperlink status

[martinsimart]

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

 

[gaz_chops]

Try

=HYPERLINK(INDEX(a3:b100,MATCH(L9,a3:a100,0),MATCH(M8,a3:b3,0)))

 

[martinsimart]

Perfect

Thank you

 

[gaz_chops]

You're welcome.