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

Steved wrote:
Hello Biff from Steved

Can I impose please and ask you to take it one more stage and that is #N/A
be blank.

Thanks.

"Biff" wrote:


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(F 6,$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.







--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.