Updating a list to include new entries

[masterbunny]

I have no neat solution for the following (I do IF statements followed by lots of hand editing). Please lift me out of the dark ages (MS access is a great solution, but I need a quick Excel solution).

I have a list like
A
B
D
F
G

with lots of lovely useful data associated

Then I discover a more comprehensive list
A
B
C
D
E
F
G
I want to use this list but keep my data associated with my originals
I usually copy/paste the new list beside my first, but of course one list is longer than the other and the data not in the correct columns to associate with the new list.
This is the end result I want:

A	A	great info
B	B	B great info
	C
D	D	D great info
	E
F	F	F great info
G	G	G great info

<tbody>
</tbody>

 

[XLearner]

Hi,

Something like this ?

	A	B	C	D	E
1	LIST 1	INFO 1		LIST 2	INFO
2	A	Info A		A	Info A
3	B	Info B		B	Info B
4				C
5	D	Info D		D	Info D
6	F	Info F		E
7	G	Info G		F	Info F
8				G	Info G
9
10
11
12
13
14
15

<tbody>
</tbody>

In E2 and copy down:

=IF(ISNA(VLOOKUP($D2,$A$2:$B$15,2,FALSE)),"",VLOOKUP($D2,$A$2:$B$15,2,FALSE))

Regards
XLearner