Hello,

I'm having a problem concatenating two columns.
I have 2 empty columns, which I then want to concatenate once
information is populated into these fields. I then want to create a
list from these two concatenated columns and have this list as a lookup
on a different worksheet.
When I create the list I highlight the entire two columns as I don't
have a predefined number of entries for the two columns.

I've done this already but when I try and lookup any of the information
I get a blank list.


Can someone please advise me on any course of action
Do I need to use an isblank method?
Many many 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=530903