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