HELP, PLEASE - Testing Multiple Values

[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

 

[renegan]

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.

 

[Carim]

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
Cari

 

[via135]

hi!

do you want something like

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

-via135

 

[wingale]

Thanks to each of you for your response. It did not work exactly, but
thats because I may noy have furnished all the info in my initial
post.

What I would like is if you could explain the formula in detail for me
so that I can understand the structure, argument, etc.

I would really appreciate that.

Thanks again,
Winston