Lookup value from another table based on two properties

[Torbennb]

I have two tables as this (example):

in table2 I want to lookup for the order number based on comparing the customer number and product number:

I tried something like this, but did not work:

If[custemer number] = tabel1(customer number) and [product number] = tabel1[product number], tabel1[order number], blank)

[Torbennb]

Thank you very much ZhangKun

[ZhangKun · Accepted solution]

You can follow the steps below without writing any code.

1. Click table2, then click the meger queries button

2. Hold down ctrl and click the columns that need to be matched, then select the table table1 that needs to be matched below, then hold down ctrl and click the columns that need to be matched (note that the order of clicks must correspond to the previous columns), and then click the OK button.

3. expand the required columns