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

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

Hello,

I'm trying to concatenate two columns of data in a different worksheet
than they are currently in. To start with there will be no data in
either column then a user will enter a name and address in the two
columns respectively and populate the two columns accordingly.
So in worksheet 2 these columns are located, I want to concatenate them
in worksheet1 and then create a drop down list in say worksheet3 with
this data.

I thought I could just concatenate them in worksheet1, define the list
and then create the list in worksheet3, so where am I going wrong?

Thanks


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

I believe you need to have the information for the list on the same worksheet
that is using the list. Someone else can confirm this.

"Max_power" wrote:


Hello,

I'm trying to concatenate two columns of data in a different worksheet
than they are currently in. To start with there will be no data in
either column then a user will enter a name and address in the two
columns respectively and populate the two columns accordingly.
So in worksheet 2 these columns are located, I want to concatenate them
in worksheet1 and then create a drop down list in say worksheet3 with
this data.

I thought I could just concatenate them in worksheet1, define the list
and then create the list in worksheet3, so where am I going wrong?

Thanks


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