ExcelBanter - Combine into one please

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Combine into one please (https://www.excelbanter.com/excel-worksheet-functions/42420-combine-into-one-please.html)

Steved

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.

Steved

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.

All times are GMT +1. The time now is 12:33 AM.