How to get the values of a column according to multiple conditions of another column?

Try

list_of_values = df[in.(df[:column1], Ref([value1, value2]),:].column2