HELP, PLEASE - Testing Multiple Values

I hope someone can help me here.

I have a workbook with two worksheets (I will call them worksheet1 and worksheet2), from worksheet1 I need to test the values of two dfferent columns with the values of two different columns in worksheet2. When both batches are true - I want to copy the value of another column, same row as the match from worksheet1 to worksheet2.

Below is my logic, I just don't know how to write in excel:
If value in column 1 of worksheet1 = value in column 1 of worksheet2 and value of column 2 of worksheet1 = value in column 2 of worksheet2, then copy the content of column 3 (same row) from worksheet1 to worksheet2.

Thanks so much!!
Winston

Assuming your first data is on row 2.

Put this formula on your worksheet 2, column 3.

=IF(AND(A2=Sheet1!A2,B2=Sheet1!B2),Sheet1!C2,"")

and copy it all the way down for all rows.

Hi,

Go to your Sheet2 in cell C2 and type :

=If(AND(Sheet1!A2=Sheet2!A2,Sheet1!B2=Sheet2!B2),Sheet1!C2,"")

I hope this is what you are aiming at ...

HTH
Cheers
Carim

hi!

do you want something like

=IF(AND(Sheet1!A1=Sheet2!A1,Sheet1!A2=Sheet2!A2),Sheet1!A3,"")

-via135

Originally Posted by wingale

I hope someone can help me here.

I have a workbook with two worksheets (I will call them worksheet1 and worksheet2), from worksheet1 I need to test the values of two dfferent columns with the values of two different columns in worksheet2. When both batches are true - I want to copy the value of another column, same row as the match from worksheet1 to worksheet2.

Below is my logic, I just don't know how to write in excel:
If value in column 1 of worksheet1 = value in column 1 of worksheet2 and value of column 2 of worksheet1 = value in column 2 of worksheet2, then copy the content of column 3 (same row) from worksheet1 to worksheet2.

Thanks so much!!
Winston