Hi,

I'm using INDEX and MATCH to look up details in another worksheet.

Part of the info is an email address. The only problem is that the email address isn't hyperlinked. Is there any way to achieve this?

Sheet 1 is several columns. Company, name, telephone, email address. Also a column (H) that has a drop down menu with 2 options. Yes, or No. This formula counts the yes' and is in column I which is hidden.

=IF(H3="Yes", "Y_"&COUNTIF($H$2:$H3,"Yes"),"")
Sheet 2 then draws all rows with a yes by using this formula

=IF(ISERROR(INDEX('Sheet 1'!A$2:A$1000, MATCH("Y_"&ROWS($A$1:$A1),'Sheet 1'!$I$2:$I$1000,0))),"", INDEX('Sheet 1'!A$2:A$1000, MATCH("Y_"&ROWS($A$1:$A1),'Sheet 1'!$I$2:$I$1000,0)))
I just need to figure out where to place the hyperlink in the above so when the email address is drawn from the first sheet it shows as a hyperlink in the second sheet.

Any help would be appreciated.