How-to find matching data in two columns and then comparing data next to them

Hi, this is a little complicated for me:

right now i use this formula :=IF(COUNTIF($C$1:$C$7000,A2),MATCH(A2,$C$1:$C$7000,0),"not found")

the data i compare is formatted like this: 1234567890-001

now i want to add a twist... i may have data that match partialy...example: 1234567890-001 and 1234567890-002

so what i need is my formula to look for a match in the first part of my data (1234567890) and if there is a match then compare if the second part matches (-001 and -002)

Is there an easy way to do that?

Thank you!

You can use LEFT and RIGHT functions to do this. Below is a simple formula. If you want a more exact formula, please upload a sample worksheet.

Example:
=IF(LEFT(A1,10)=LEFT(A2,10),IF(RIGHT(A1,4)=RIGHT(A2,4),"Match","Partial Match"),"No Match")