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
Bookmarks