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

Doesn't work


cell in column X=CVE-2007-1205, 2007-A-0020

  • Welcome to Super User! You can freely edit your own posts but for your protection, this must be done under the original user account. It looks like you have created a second account, which will also interfere with your ability to comment within your thread and to accept an answer. See Merge my accounts to get your accounts merged, which will solve the problem. – fixer1234 Mar 14 '17 at 22:07

This worked:

=INDEX('Sheet'!B:B, MATCH("*" & E2 & "*", 'Sheet'!X:X, 0))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.