|
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. |
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. |
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. |
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. |
=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. |
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. |
| All times are GMT +1. The time now is 11:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com