Is this possible please if so How. Thankyou.

[Guest]

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.

 

[Biff]

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

 

[Guest]

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.

 

[Guest]

It's ok I looked up and found away

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

Thankyou.

 

[Aladin Akyurek]

=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),"")

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.

:

--

[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.

 

[Guest]

Hello aladin from Steved

Yes much clearner Thankyou.

=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),"")

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.

:

--

[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.