Excel Questioj

[Graham]

here goes i have 2 lists of information both with a unique key field that exists in both lists.

now the 2 lists cont have the same number of rows.

list one has all items list 2 is a subset of list one with some additional data.


what i need to do is match up the two lists in excel.


i.e at the moment i have t sorted lists that go somthing like

list1 list2
1 1
2 2
3 4
4 5
5 7
6
7
8



i need to match up the 2 lists in excel so all the row s from the two files line up in one list



new list

1 1
2 2
3
4 4
5 5
6
7 7
8

with the rest of the columns from the 2 lists lining up accordingly.



can i do this in excel ????



cheers


graham

[Graham]

sorted ta


PH the font of all knowledge ( if not spelling)

[Graham]

vlookup workted fine using the false option on all the lookup fields.

there was only 11k items in the master list and 10k in the secondary list with 5 fields in the second list to match up.



both lists were sorted but it still takes a while to format !!!!

the file comes out at3.6mb!!


cheers Guys

G