EXCEL, If column terms match text In range b equal to or less then, the insert other column : I 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][1]



    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


  [1]: http://i.stack.imgur.com/c1BXe.png