Search and return
 

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

Search and return
 

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

Search and return
 

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




John21



The problem is that the names in the column appear more than one time
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,468


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