Struggling with data matching

[VanessaDowning]

Supplier acc#	PO	Email address	Acc name
ALAN03	839766		Alan Evans
BLUE01	839777		Blue Seal
FIRS02	839888		First Choice
EAST01	89999		East Anglian
MEIK01	829999		Meiko

<tbody>
</tbody>

Hi - above is a list of orders (table # 1) where I need to retrieve email addresses from a 2nd table.

The common field between both tables is the supplier acc # (eg: ALAN03). I need to find ALAN03 in table #2 and populate the email address associated with ALAN03 in table # 1. Please can you help? Tried all forums - struggling so much

SECOND TABLE IS:

ACC # Acc Name Email Address
BOBS01 Bobs may bobsmay@hotmail.com
DEMD01 DEM Sols demsolutions@gmail.com
BLUE01 Blue Sky bluesky@sky.com
MEIK01 Meikel Ltd meikel2@yahoo.com
ALAN03 Alan Chip aland@mail.com

Please can you help with a formula? Thank you

 

[steve the fish]

A vlookup such as:

=VLOOKUP(A2,table2,3,0)

 

[VanessaDowning]

Steve the fish - you are a super-star!!!! Do you know how long I've spent looking for this? Thank you so very much. Feel a bit silly now, as it seems so simple Thanks again. Stress over