Thread: blank list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max_power
 
Posts: n/a
Default blank list


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