I'd probably concatenate the info this way:

T_LOCATIONS!A2 &" \"&T_LOCATIONS!B2

You have an additional \ in your concatenate statement that may not work
(after the first comma)

T_LOCATIONS!A2,\" \",T_LOCATIONS!B2

If you concatenate this together and A2 and B2 are blank, you'll always get
" \", so it never will be blank.

What exactly do you want to do with this?


"Max_power" wrote:


Hello,

I'm quite new to excel so please forgive me.
I've concatenated two tables from a different worksheet ie
=IF(NOT(ISBLANK(CONCATENATE(T_LOCATIONS!A2,\"
\",T_LOCATIONS!B2))),CONCATENATE(T_LOCATIONS!A2 ,\"
\",T_LOCATIONS!B2))
I define this as say -name-
I've now created a list on another worksheet and I use "name" as a
reference point, the thing is as name populates the list remains empty.
Do I need to do a vlookup or should it work????

Thanks in advance

Max


--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=526049