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

Question

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 IDDS-228, DS-759

Sheet 2:

KeyLinks EL-2635O-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.

geeklarokcmie · Answer

Thank you, Qiu.

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

Qiu · Answer

@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.

0907-geeklarokcmie.yxmd