Replace value x from y given the condition is true

[andy12]

Hello, 

I am trying to replace a column of a set of data to the value "X" IF the column's customer order id is equal to the values in another excel sheet, how should i approach this problem.

Thank you. 

[tackytechtom]

Hi @andy12 ,

I'd probably do a left outer join and then apply your logic. Can you share some sample data?

Thanks!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/