Hi!

so cell A1 ="ADDISON Mark James"

=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)

so cell A1 ="ADDISON
Mark James" (Wrap Check box ticked)

=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6, $U$2:$Z$2000,3,0)

Biff

"Steved" wrote in message
...
Hello from Steved

Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
James"

Ok can I get the formula to combine the both to get = "ADDISON Mark James"

so cell A1 ="ADDISON Mark James"
or
so cell A1 ="ADDISON
Mark James" (Wrap Check box ticked)

Thankyou.