Lookup to find a match between two sheets and hyperlink the corresponding column value

[geeklarokcmie]

Hello Experts.

Seeking to solve the below: 

I've go two sheets as mentioned below - and need to lookup to find a match in both sheets and then populate the value of the corresponding column by hyperlinking to it. 

Sheet 1:

JIRA ID

DS-228, DS-759

Sheet 2:

Key	Links
EL-2635	O-001, DS-759, DS-781

Desired Output:

Sheet 1

JIRA ID	Key
DS-759	EL-2635
DS-228	No Match

EL-2635 in desired output must be hyperlinked to the value in Sheet2.

[Qiu]

@geeklarokcmie 

We can first use Text to Column tool split JIRA ID column to single string then use Append and Formula tools to find the match.

[geeklarokcmie]

Thank you, Qiu.

How can I hyperlink the Key Column to the value in Sheet 2?