Please Help with Two Table Merging

[wingale]

I have posted this question before and maybe need to add more info. 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.

Each worksheet contains about 300 records, each column has a title
(fieldname). I have given each data table a range name.

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.

Please, please, can someone tell me how to do this and possibly write
the code and explain each part of said written ode for my
understanding.


Thanks so much!!
Winston

 

[Ardus Petus]

In Worksheet2, cell C2:
=SUMPRODUCT((Worksheet1:A$2:A$300=A2)*(Worksheet1!B$2:B$300=B2);C$2:C$300)
then copy down

HTH
--
AP

"wingale" <[email protected]> a écrit
dans le message de
news:[email protected]...