Power Query: search multiple columns against a list of values?

[little ribbit]

I am trying to move an excel SUMPRODUCT function into Power Query.
The function searches a column against a list of names in a table, then returns TRUE if one is found.
Code sample:
IF ( SUMPRODUCT ( ISNUMBER ( SEARCH ( Table[Column], [@[current_field]] ) ) * ROW ( $rows included in Table[Column] ) ) >0, TRUE, FALSE )

There are seven (7) columns to check for each record so I put all of the separate SUMPRODUCT functions within an OR ( ) clause.
IF ( OR ( SUMPRODUCT ( ISNUMBER ( SEARCH ( Table[Column], [@[first_field]] ) ) * ROW ( $rows included in Table[Column] ) ) >0,
SUMPRODUCT ( ISNUMBER ( SEARCH ( Table[Column], [@[second_field]] ) ) * ROW ( $rows included in Table[Column] ) ) >0,
...
SUMPRODUCT ( ISNUMBER ( SEARCH ( Table[Column], [@[seventh_field]] ) ) * ROW ( $rows included in Table[Column] ) ) >0), TRUE, FALSE )

Does Power Query have an analogous function or functionality to accomplish this task?

Background: The report collects data in Excel then links to Access for table joins and processing.
I need to see if I can move this very manual report out of Access and completely into Excel.

 

[Matt Allington]

I’m sure you can move from Access to Power Query/Excel, but I doubt you will find the solution if you try to find a similar function. Power Query is very different to Excel and hence it solves problems in different ways. It is better to explain your source data and the output you need and see if someone can help with a suggested approach.