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


--
wingale
------------------------------------------------------------------------
wingale's Profile: http://www.excelforum.com/member.php...o&userid=33467
View this thread: http://www.excelforum.com/showthread...hreadid=533039

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.


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=533039

Hi,

Go to your Sheet2 in cell C2 and type :

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

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

HTH
Cheers
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=533039

hi!

do you want something like

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

-via135

wingale Wrote:
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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=533039

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


--
wingale
------------------------------------------------------------------------
wingale's Profile: http://www.excelforum.com/member.php...o&userid=33467
View this thread: http://www.excelforum.com/showthread...hreadid=533039