I am using the following formula:
=INDEX(array, MATCH(lookup_value, lookup_array, 0))
Exactly it looks like:
=INDEX('Sheet B'!B:B, MATCH(E2, 'Sheet B'!X:X, 0))
The problem is it works for all cases where cells in Column X have only the lookup_value. I need a formula that will consider it a match if it finds this exact 13 character value but also contains other text.
cell in column X=CVE-2007-1205
cell in column X=CVE-2007-1205, 2007-A-0020