Compare 3 Columns and Return all Matches

(Sample Workbook uploaded)

Hi,

I need to fill in the empty/missing values in Column P (sheet1). These values are to be found in Sheet2 Column A through the following procedure:

- Compare the data in the 3 columns of Sheet1 (E, F and H) with the data in the 3 Columns of Sheet2 (E,H, and F) respectively.
- If all the 3 columns match each other (E=E, F=H and H=F) then copy the value from the respective row cell in Column A Sheet2 and paste it to the respective row cell in Column P Sheet1.
- In case of multiple matches, all the matching values found in Column A Sheet2 should be pasted in Column P Sheet1 separated by a comma.

I hope you can help me with this. Either via VB Code (macro) or an Excel procedure.

Thank You,
JN

Posting here:
http://www.mrexcel.com/forum/showthread.php?p=2520024

Here is the solution code below provided by a friend.

I need to modify the code to compare the columns in sheet 1 (E, F and H) with the columns in sheet 2 (AG, AM, AH). The rest procedure is the same. Where do I need to edit ?

The data starts on sheet 1 from row 2 to row 1260 (column A to Q)
The data starts on sheet 2 from row 5 to row 3861 (column A to DK)

Please Login or Register  to view this content.