I vote for the CONCATENATION option...........I use it all the time.
Vaya con Dios,
Chuck, CABGx3
"Shirley Munro" wrote:
Hi
I want to carry out a Vertical Lookup but the Lookup Value is contained
in 2 columns. Can this be done or would it be best to Concatenate the 2
columns into one?
Thanks
Shirley Munro
--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=493021