John21 wrote:

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

Hi John21

If you enter the name to lookup in cell C1, try:

=VLOOKUP(C1,A1:B4,2,FALSE)

Regards

Steve