Hi,

I’m looking for a way to search information in a column and then return
the text found in another column that has related information. For
example:


Column1 Column2
John E,U4,L5
Angel HU,5,Lm
Jenny
Pedro 54,lkj,5UJ

John return: E,U4,L5
Angel returns: HU,5,Lm
Pedro return:54,lkj,5UJ

So far i've using SUMPRODUCT with T.


--
John21
------------------------------------------------------------------------
John21's Profile: http://www.excelforum.com/member.php...o&userid=36983
View this thread: http://www.excelforum.com/showthread...hreadid=569067