PDA

View Full Version : Compare 3 Columns and Return all Matches



jimmynora
11-21-2010, 10:34 AM
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

Bob Phillips
11-22-2010, 01:24 AM
Cross-posted at Xtreme VBTalk http://www.xtremevbtalk.com/showthread.php?t=319192