EXCEL, If column terms match text In range b equal to or less th

Ive been racking my brain, the attached photo illustrates roughly what Im trying to do, top and bottom images illustrates a collection if 12k pictures I need to associated the id depicted in the middle portion of the attached image.... what I have ... i know im going the wrong way and my job is kinda depending on this... lol HELP! I know ive been going VBA but if a formula would work... I just need this bad.

Buy ya a coffee if you can help me out in anyway.

What Im trying to accomplish



I have a VBA macro buil but IKNOW im going about it wroing...

Sub Find_Matches()
    Dim CompareRange As Variant, ToCompare As Variant, x As Variant, y As Variant
    Set CompareRange = Worksheets("ID_proptitle").Range("B1:A500")
    Set ToCompare = Worksheets("pictures").Range("B1:C500")
    For Each x In ToCompare
        For Each y In CompareRange
            If x = y Then