Struggling with data matching

VanessaDowning

New Member
Joined
Jul 1, 2013
Messages
4
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 :)
 

VanessaDowning

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

Forum statistics

Threads
1,085,294
Messages
5,382,768
Members
401,804
Latest member
RB85

Some videos you may like

This Week's Hot Topics

Top