dimitrisanto13
New Member
- Joined
- Nov 2, 2022
- Messages
- 3
- Office Version
- 365
I have one sheet with the emails and the names for each one.
Then i have another sheet where i use a hyperlink vlookup formula.
There is no problem it returns all the emails for each one but when i press on them it opens only the first email of the table .
For example i want to press the 4th email of my table where i use the vlookup and it opens only the first one .
My formula is that =Hyperlink(vlookup([@investors],table4[[investors];],2,FALSE))
investors is the one table with the names and emails is the other tables with the emails
I already tried it without the hyperlink and has the same result still can open another email except the first of the table.
Is there any way to open an email from the table with the vlookup and open it and not open only the first of the table email?
Thanks a lot i hope u understand what i am trying to say and help me solve this
Then i have another sheet where i use a hyperlink vlookup formula.
There is no problem it returns all the emails for each one but when i press on them it opens only the first email of the table .
For example i want to press the 4th email of my table where i use the vlookup and it opens only the first one .
My formula is that =Hyperlink(vlookup([@investors],table4[[investors];],2,FALSE))
investors is the one table with the names and emails is the other tables with the emails
I already tried it without the hyperlink and has the same result still can open another email except the first of the table.
Is there any way to open an email from the table with the vlookup and open it and not open only the first of the table email?
Thanks a lot i hope u understand what i am trying to say and help me solve this
