How to make essentially an XLOOOKUP with multiple lookup value conditions?

I have two datasets, which need to be “joined” in such way, that I search for multiple column match end replace the values in the return area (which also has multiple columns).

Example:

Values to be searched: Invoice Number, Product, Serivce Type, Period, Product Category, Customer Name

Values to be replaced: Sales 2024-01, Sales 2024-02, Sales 2024-03, Sales 2024-04, etc.

Each dataset has the same columns so the values to be searched, can also be found in the dataset from which I want to take the values. And this dataset from which I want to take the value sand replace the values in the lookup dataset, has also the columns Sales 2024-01, SAles 2024-02, etc.

How should I approach the problem in KNIME?