| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Combine into one please
Hello from Steved
=IF(ISNA(VLOOKUP(E6,$T$2:$Y$2000,6,0)),"",VLOOKUP( E6,$T$2:$Y$2000,6,0)) =U2&CHAR(10)&V2 ok =U2&CHAR(10)&V2 combines the 2 values into 1 (surname and first names) Please can I put it into =IF(ISNA(VLOOKUP(E6,$T$2:$Y$2000,6,0)),"",VLOOKUP( E6,$T$2:$Y$2000,6,0)) as then it would only lookup one cell, as it looks up 2 at the moment. Thankyou. |
|
#2
|
|||
|
|||
|
Hello from Steved
Ignore please "Steved" wrote: Hello from Steved =IF(ISNA(VLOOKUP(E6,$T$2:$Y$2000,6,0)),"",VLOOKUP( E6,$T$2:$Y$2000,6,0)) =U2&CHAR(10)&V2 ok =U2&CHAR(10)&V2 combines the 2 values into 1 (surname and first names) Please can I put it into =IF(ISNA(VLOOKUP(E6,$T$2:$Y$2000,6,0)),"",VLOOKUP( E6,$T$2:$Y$2000,6,0)) as then it would only lookup one cell, as it looks up 2 at the moment. Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine text from multiple cells? | Excel Worksheet Functions | |||
| In Excel combine tables from multiple worksheets in to one sheet? | Excel Worksheet Functions | |||
| How do you combine two columns to one? | Excel Discussion (Misc queries) | |||
| Combine two formulas in one cell | Excel Discussion (Misc queries) | |||
| how to combine multiple files in ms excel | Excel Discussion (Misc queries) | |||
Linear Mode
