Is it possible to match based on partial data in 2 fields

[Jaimee001]

Hi All,
I thought this would be easy but I'm not able to find anything. I have a report where 2 of the columns differ by just the first byte (?)

I00063 000063

Is there a formula that I could use to make a match on the bytes after the first one?
I've attahced an example report. Hopefullly, this all makes sense

I could do a text to column and then match but that would be adding addtional columns to the report.

Thank you in advance
Regards,
Jaimee

 

[azumi]

Put in C2 and copied down

=IF(RIGHT(A2,5)=RIGHT(B2,5),"Yes","No")

 

[Jaimee001]

thank you thank you thank you!!!!!