Compare two lists in Sheet 1 & 2 Column A, then combine the match adjacent cells in sheet3

Hello,

I have two lists of information, each list is a different length and only one column will have matches (column A). I have a list in sheet 2 and need to find the matching results in sheet 1 and then combine the adjacent information from sheet 2 and sheet 1 into sheet 3.

I have searched everywhere for something close to what I require, but can't seem to find anything that works. I have written some code but it only returns one result.

Please Login or Register  to view this content.

Can anyone help me please, even point me in the right direction and I can change the code to fit my needs.

Thank you for any help in advanced.

Raulos,
Please attach a sample with a desired result.

Thanks AB33, I have attached an example, with how I want the result on sheet 3.

Example.xlsx

Try the attached.

AB33, thank you so much! It worked perfectly, I really appreciate your help.

Paul

Paul,
You are welcome!