Hello all,

I have a table in Sheet1 like this.

K1vhE.jpg

In Sheet2, I have the following table.

eYGZv.jpg

So how can I ask excel (or Google Sheets) to fill in the Data1 and Data2 column like this:

If select1, select2 and select3 in sheet1 is equal to its equivalent in sheet2, then fill in data1 in sheet1 using the value in sheet2.

Thank you in advance for your help