Lookup based on text.contains from one table to another in Power query

[Powerbi_user26]

Hi,
I am trying add a custom column by doing a  lookup from my Keywords_Con table to Index_Con table in Power Query.
keywords_Con table is having multiple words separated by "," which I am trying to do a lookup using text.contains.
Requirement : If first word from keywords_Con matches the Index_Con Keyword column then return the Index number.

Keywords_Con :

Keywords

Citrix,Frozen,Session,Citrix

devops,Bot

RPA ,Bot

Index_Con:

Keywords	Index
Citrix	1
Devops	2
Bot	3
RPA	4

Code 

if (Text.Contains([Keywords], Index_con[keywords]))
then Index_con[Index] 
else null

 
Expected results in Keyword_Con table

keywords	Index
Citrix,Frozen,Session,Citrix	1
devops,Bot	2
RPA ,Bot	4

Thanks in Advance 

[MNedix · Accepted solution]

Hi,

I did the following:
1. I've split the Keyword_COn table in Power QUery by Comma delimiter

2. In the Keyword_Con table I've created the below column

New_Index = LOOKUPVALUE(Index_Con[Index],Index_Con[Keywords],Keywords_Con[Keywords.1])

If this solves your problem then please mark it as the solution.