Pull first end customer for each account

Hi,
Can someone help me w/ a formula that will pull ONLY the first end customer name for each account?

For example, based on the attached...

Account A: 1
Account B: BB
Account C: DD

Thanks!
example_lookup.xlsx

Like this...

Data Range

	A	B	C	D	E
1	Account	End Customer	------	Account	End Customer
2	A	1		A	1
3	A	2		B	BB
4	A	3		C	DD
5	A	4
6	A	5
7	A	6
8	B	BB
9	B	DE
10	B	FG
11	B	EG
12	B	AD
13	C	DD
14	C	EG
15	C	AE
16	C	12
17	C	3
18	C	5

This formula entered in E2 and copied down:

=VLOOKUP(D2,A:B,2,0)

Try this:

Formula:

Please Login or Register  to view this content.

Change the A2 to a different reference containing the Account you want to look up if desired.

You're welcome. We appreciate the feedback!