Combining lists

Hi all,

I've had a search through historic posts, but there doesn't seem to be a definitive answer for this one.

How can we combine two lists, where items have a unique identifier common to both lists? The hitch: The unique identifier from list two may not appear in list 1, or vise vera. Nor are the identifiers likely to be in the same order.

In the example below, the aim is to combine two lists - one containing the unique identifier "Name", a "Top", and "Bottom" value, and the other list containing the unique identifier "Name", an "Easting", "Northing", and "RL" value.

The unique identifier found in list 1 may be found in a completely different line in list 2. so essentially I'm trying to match data line by line with its counterpart.

Example XLSX
CombineLists.xlsx

Result
CombinedList.jpg

List 1
List1.jpg

List 2
List2.jpg

As always, your help is very much appreciated.

Thank you!

Please attach a sample workbook by showing the expected output for giving exact solution

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info)