| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is this possible please if so How. Thankyou.
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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(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. |
|
#4
|
|||
|
|||
|
It's ok I looked up and found away
=IF(ISNA(VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLO OKUP(F6,$U$2:$Z$2000,3,0)),"",VLOOKUP(F6,$U$2:$Z$2 000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)) Thankyou. "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(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. |
|
#5
|
|||
|
|||
|
=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. |
|
#6
|
|||
|
|||
|
Hello aladin from Steved
Yes much clearner Thankyou. "Aladin Akyurek" wrote: =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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum product help needed with an extra variable please and thankyou | Excel Worksheet Functions | |||
Linear Mode
