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 :)
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

VanessaDowning

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

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,964
Members
413,955
Latest member
FalcoDaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top