VanessaDowning
New Member
- Joined
- Jul 1, 2013
- Messages
- 9
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