Search and return

J

John21

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.
 
S

Scoops

John21 said:
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.
Click to expand...

Hi John21

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

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

Regards

Steve
 
J

John21

Hi,
I'm looking for a way to search information in a column and the 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.
Click to expand...

Hi John21

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

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

Regards

Steve




RE: John21



The problem is that the names in the column appear more than one tim
and the names appear randomly.
Another exmaple:

John lmj,45
Maria HI45,kil
Jose
John U15,U78
John M60,lem
Angel lktr
Jenny
Angel nono,468
Maria


John return: lmj,45,U15,U78,M60,lem
Angel return: lktr,nono,46
 
Top