Find multiple strings of data in data set and return values if found

[Peptide]

Hello,
I am looking to see if i can do the following in a formula only. I have a headache from trying so hoping one of you experts can lend a hand i would be grateful. Thanks in advance!

Note
I used cells a,b,c,d,e etc to make the example easy, but I need to be able to use this anywhere in a worksheet. Once I figure it out, I need to be able to cut/paste to other parts of the worksheet.

Logic
Find C1 in data range A1:B5, for each time it finds the value, show the value in column D and E as noted below. When it no longer finds anymore C1, find C2, then C3 etc.

Data Range A1:B5
ABCDE Exact Match 10
BCDEF Exact Match 20
CDEFG Exact Match 40
ABCDE Exact Match 200
CDEFG Exact Match 500

C1=ABCDE
C2=BCDEF
C3=CDEFG
C4=DEFGH

Result looks like this
D1=ABCDE E1=Exact Match 10
D2=ABCDE E2=Exact Match 200
D3=BCDEF E3=Exact Match 20
D4=CDEFG E4=Exact Match 40
D5=CDEFG E5=Exact Match 500

 

[Peter_SSs]

You are very welcome Bob. Thanks for your kind remarks.

Edit: I just noticed that my D2 formula did not display correctly. The forum software causes a problem when a < sign is followed immediately by a letter. I have edited the formula in my previous post but it seems you must have figured out anyway that the red part here was originally missing from that formula.

=IF(ROWS(D$2:D2)<MAX(F$1:F$8),INDEX(C$2:C$8,MATCH(ROWS(D$2:D2),F$1:F$8,1)),"")

 

[Peptide]

Thanks Peter,
I was getting and error and re-looked and saw did see that - not bad for a rookie that I could find the issue! As always thank you for your help!

Bob

 

[Peter_SSs]

.. did see that - not bad for a rookie that I could find the issue!