Need help with multiple IF ISNUMBER SEARCH excel function in Power Query

Hi,

I am working with Qualys vulnerability excel data of 30-50k rows where in currently using "if isnumber search" excel function in column-B of the attached file.

There are ~ 28 to 30 different text string from another sheet needs to be compared with a single cell in Titel column and then update column-B.

I need some help to get this done using power query. 

I have attached sample file for your reference and looking power query to achieve this formula.

Unable to attach my file but this is the formula in Col-B of Table1.

=IF(ISNUMBER(SEARCH(CustomCategory!$A$2,$F2)),CustomCategory!$B$2,

IF(ISNUMBER(SEARCH(CustomCategory!$A$3,$F2)),CustomCategory!$B$3,

IF(ISNUMBER(SEARCH(CustomCategory!$A$4,$F2)),CustomCategory!$B$4,

IF(ISNUMBER(SEARCH(CustomCategory!$A$5,$F2)),CustomCategory!$B$5,

IF(ISNUMBER(SEARCH(CustomCategory!$A$6,$F2)),CustomCategory!$B$6,

IF(ISNUMBER(SEARCH(CustomCategory!$A$7,$F2)),CustomCategory!$B$7,

IF(ISNUMBER(SEARCH(CustomCategory!$A$8,$F2)),CustomCategory!$B$8,

IF(ISNUMBER(SEARCH(CustomCategory!$A$9,$F2)),CustomCategory!$B$9,

IF(ISNUMBER(SEARCH(CustomCategory!$A$10,$F2)),CustomCategory!$B$10,

IF(ISNUMBER(SEARCH(CustomCategory!$A$11,$F2)),CustomCategory!$B$11,

IF(ISNUMBER(SEARCH(CustomCategory!$A$12,$F2)),CustomCategory!$B$12,

IF(ISNUMBER(SEARCH(CustomCategory!$A$13,$F2)),CustomCategory!$B$13,

IF(ISNUMBER(SEARCH(CustomCategory!$A$14,$F2)),CustomCategory!$B$14,

IF(ISNUMBER(SEARCH(CustomCategory!$A$15,$F2)),CustomCategory!$B$15,

IF(ISNUMBER(SEARCH(CustomCategory!$A$16,$F2)),CustomCategory!$B$16,

IF(ISNUMBER(SEARCH(CustomCategory!$A$17,$F2)),CustomCategory!$B$17,

IF(ISNUMBER(SEARCH(CustomCategory!$A$18,$F2)),CustomCategory!$B$18,

IF(ISNUMBER(SEARCH(CustomCategory!$A$19,$F2)),CustomCategory!$B$19,

IF(ISNUMBER(SEARCH(CustomCategory!$A$20,$F2)),CustomCategory!$B$20,

IF(ISNUMBER(SEARCH(CustomCategory!$A$21,$F2)),CustomCategory!$B$21,

IF(ISNUMBER(SEARCH(CustomCategory!$A$22,$F2)),CustomCategory!$B$22,

IF(ISNUMBER(SEARCH(CustomCategory!$A$23,$F2)),CustomCategory!$B$23,

IF(ISNUMBER(SEARCH(CustomCategory!$A$24,$F2)),CustomCategory!$B$24,

IF(ISNUMBER(SEARCH(CustomCategory!$A$25,$F2)),CustomCategory!$B$25,

IF(ISNUMBER(SEARCH(CustomCategory!$A$26,$F2)),CustomCategory!$B$26,

IF(ISNUMBER(SEARCH(CustomCategory!$A$27,$F2)),CustomCategory!$B$27,

IF(ISNUMBER(SEARCH(CustomCategory!$A$28,$F2)),CustomCategory!$B$28,"Legacy Patches")))))))))))))))))))))))))))

Table2: CustomCategory

Vulnerability title contains      Custom Category