Hello,

Just need some advice with regards to the below.

I have 2 tables.

The first consists of 1 column of names and several other columns of other
details. This table contains the records of people i need to update with
details of the 2nd table....

The 2nd table contains 2 columns of the same names but split, with first
name being in a separate column than the surname. Then further columns that
have more info in. This table has 11000 peoples names in as this data is a
simple data dump, opposed to the exact names of the people in table 1 i need.

I will use a v look up but after i have concatenated table 2 - is this going
to work? Or is there a better way?

Comments and advice would be greatly received,

Many Thanks

kelly m johnson