Combine into one please

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup 6
#N/A! to be blank please. 1
Is this possible please if so How. Thankyou. 5
Character 3
function returning SUM of 2 adjacent cols in 2 separate cells 7
Surname and First names formula 8
Multiple functions/formulas... 3
VBA format of cells with colour based on IF formula 2

Top