find a text - help
 

Hello all

could you please tell me how to find a specific text in a range of
columns and than print all the values found for that first value.
EX.

column A1 to B10 has four different type of data (names)
column C1 to D10 has a range of dates related to their names.

Column E1 (enter name to be found)
Column F1 ( results from the search of the dates related to the name
input on E1 cell.

Thank You,
Edson


--
edagostini
------------------------------------------------------------------------
edagostini's Profile: http://www.excelforum.com/member.php...o&userid=31950
View this thread: http://www.excelforum.com/showthread...hreadid=516713

find a text - help
 

If there are multiple dates to return you want them all in one cell?

Perhaps

=MCONCAT(IF(A1:B10=E1,TEXT(C1:D10,"d-mmm-yy "),""))

confirmed with CTRL+SHIFT+ENTER

MCONCAT function is part of MOREFUNC add-in available here

http://www.rhdatasolutions.com/morefunc/#MCONCAT


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=516713