Help with VLOOKUP - lookup value is a part of a string

[TiberSeptim]

Hello everyone,

I need help with this situation:

In the Sample file, the lookup value in D2 (ITDC81200372) is only a part of multiple codes in one cell in column 1 (A3:GBQRF0705817,ITDC81200372,USA560633118,USA560702350,USMC16046323,USNPD0801644,USSM16400141,USX7N0915346,USXTH0602170)

Is there any way that i can vlookup a value contained in column 1 and give results in column 2?

Thank you!

[bebo021999]

This formula return the last occurence that D2 found in column A (if there were duplicate D2):

Please Login or Register  to view this content.

or, more neater:

Please Login or Register  to view this content.

[Bo_Ry]

Return the first occurrence.

=VLOOKUP("*"&D2&"*",A2:B81,2,)

[TiberSeptim]

Thank you very much! Your formula works perfectly!