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