Struggling with data matching

[VanessaDowning]

[TABLE="width: 50"]
<tbody>[TR]
[TD]Supplier acc#
[/TD]
[TD]PO
[/TD]
[TD]Email address
[/TD]
[TD]Acc name
[/TD]
[/TR]
[TR]
[TD]ALAN03
[/TD]
[TD]839766
[/TD]
[TD][/TD]
[TD]Alan Evans
[/TD]
[/TR]
[TR]
[TD]BLUE01
[/TD]
[TD]839777
[/TD]
[TD][/TD]
[TD]Blue Seal
[/TD]
[/TR]
[TR]
[TD]FIRS02
[/TD]
[TD]839888
[/TD]
[TD][/TD]
[TD]First Choice
[/TD]
[/TR]
[TR]
[TD]EAST01
[/TD]
[TD]89999
[/TD]
[TD][/TD]
[TD]East Anglian
[/TD]
[/TR]
[TR]
[TD]MEIK01
[/TD]
[TD]829999
[/TD]
[TD][/TD]
[TD]Meiko
[/TD]
[/TR]
</tbody>[/TABLE]

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