Compare Two Lists

[MidnightMonkey]

Howdy Everyone

So I am really scratching my head here, I have tried everything and just cannot get it right

I have two large lists List1 and List2,

can I compare a column in each list and if there is a match it should display a column from within list two?

Thank you in advance

 

[Joe4]

Welcome to the Board!

Depending on your data structure, perhaps use a VLOOKUP or INDEX/MATCH formula?
See: https://www.techonthenet.com/excel/formulas/vlookup.php
and
https://fiveminutelessons.com/learn-microsoft-excel/how-use-index-match-instead-vlookup

If you still need help, please print some small data examples of your two lists, and what you are trying to return, so we have a clear understanding of your data structure and desired result.

 

[MidnightMonkey]

Hi there

and thank you, pleased to be here

I am really not clued up with formulas. Below are my two lists, what I want to achieve is list 2 must be compared to list 1 by company name if there is a match it should copy to number to list 1

here are my two snapshots of lists

List 1

<colgroup><col style="mso-width-source:userset;mso-width-alt:14506;width:306pt" width="408"> <col style="mso-width-source:userset;mso-width-alt:2787;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:3555;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:4579;width:97pt" width="129"> </colgroup><tbody>
[TD="class: xl65, width: 408"]3D Industrial Sales & Service, Inc.[/TD]
[TD="class: xl66, width: 78"]Jim[/TD]
[TD="class: xl66, width: 100"]Pellegrino[/TD]
[TD="class: xl66, width: 129"]US[/TD]

[TD="class: xl65"]A 1 Pumps & Motors, Ltd.[/TD]
[TD="class: xl66"]Ron[/TD]
[TD="class: xl66"]Du Plessis[/TD]
[TD="class: xl66"]New Zealand[/TD]

[TD="class: xl65"]A&A Electric Motor Repair, Inc.[/TD]
[TD="class: xl66"]Carl[/TD]
[TD="class: xl66"]Unrue[/TD]
[TD="class: xl67"]US[/TD]

[TD="class: xl65"]A&A Electric Motor Repair, Inc.[/TD]
[TD="class: xl66"]Carl[/TD]
[TD="class: xl66"]Unrue[/TD]
[TD="class: xl66"]US[/TD]

[TD="class: xl65"]A&A Electric Motors & Pumps Sales & Service, Inc.[/TD]
[TD="class: xl66"]Andy[/TD]
[TD="class: xl66"]Maraj[/TD]
[TD="class: xl67"]US
[/TD]

</tbody>

List 2

<colgroup><col style="mso-width-source:userset;mso-width-alt:14506;width:306pt" width="408"> <col style="mso-width-source:userset;mso-width-alt:7168;width:151pt" width="202"> </colgroup><tbody>
[TD="class: xl65, width: 408"]3D Industrial Sales & Service, Inc.[/TD]
[TD="class: xl65, width: 202"]516-876-2600[/TD]

[TD="class: xl65"]A 1 Pumps & Motors, Ltd.[/TD]
[TD="class: xl65"]64-9-2639913[/TD]

[TD="class: xl65"]A&A Electric Motor Repair, Inc.[/TD]
[TD="class: xl65"]803-648-0159[/TD]

[TD="class: xl65"]A&A Electric Motors & Pumps Sales & Service, Inc.[/TD]
[TD="class: xl65"]407-843-5005[/TD]

[TD="class: xl65"]A&B Electric Co., Inc.[/TD]
[TD="class: xl65"]808-682-4024[/TD]

[TD="class: xl65"]A&C Electric Co.[/TD]
[TD="class: xl65"]586-469-0710[/TD]

</tbody>

Hope this makes sense

 

[Joe4]

Since the column you are matching on is the first column in each list, the VLOOKUP option should work very well here.

Take a look at the VLOOKUP article I linked to in my previous post. It gives you a detailed explanation and walks you through examples.
If you cannot get it to work, post the formula that you came up with here, and we will help you fix it up.