Setting up a conditional column in power query, using values in a separate table to check if they are in 2 columns.

[Db-why-not]

I have 2 colums in my table: created_dataflow and updated_dataflow column in my table that will list different people. I want to create a conditional column [DS_involved] that checks these 2 columns for specific people. I have (table DS) with 1 column that lists people I want this conditional column to check for , it's a long list of people that I don't want to have to list every person. I want to just refer to this tables column.

If [updated_dataset] = ds table values or if [created_dataset] = ds table values
Then [ds_involved]= "yes" else "no"

I want something like that logic but I don't know the correct syntax to use in power query for this?

I'm not sure how to get those 2 columns to check in my ds table for those list of people? If any of the names on the list are in either column then I want that ds_involved column to =yes
Thanks for any help you can provide.

 

[arnelgp]

you may try to use these formula:

=IF(ISERROR(VLOOKUP(A2,TheOtherSheet!A:A,1,0)),"No","Yes")

you can always upload a sample workbook to work with.

//Edit: see demo.