Return earliest date a name appears in a column (within group of names)

[jlive24]

Hi All,

I have a spreadsheet that contains a list of transactions. Column A contains each transaction ID, Column B contains all individuals involved in the transaction (delimited with semi-columns), column C contains the transaction dates, and Column E contains a list of all unique individuals. For each individual in Column E, I would like to return the date of the earliest transaction they were a part (this would go in Column F). Please see image below.

I believe I would know how to do this if Column B only contained unique names, but am having trouble since I'm having to search for partial text. Any suggestions?

 

[Fluff]

How about
=index(C$2:C$100,match("*"&E2&"*",B$2:B$100,0))

Although this will not find "Peter, James" as in column B it's "James, Peter"

 

[jlive24]

Thanks! This worked.

 

[Fluff]

You're welcome & thanks for the feedback.