Need a formula that performs a match but not an exact match

I have two colums of data that match somewhat. The first column is always 6 characters (they are unique identifiers) and the third column is also 6 characters but some of the data is cut off. For instance column 1 may have the text 4T2597 and column 3 might just have 2597 or 597. When i use the match function it does not pick up that they are the same data. I want to make it so that if there are atleast 3 or 4 characters in column 3 (havnt decided if i will make the threshold 3 or 4) that are the same within column 1 that it says they are a match.

There are also dollar values in columns 2 and 4 that go with each unique identifier. The grand scheme is to have a series of formulas/macros that looks at the data in columns 1 and 2 and determines if there are matches for that same data in columns 3 and 4. So if Cell A1="4T2597" and Cell B1="$45,010.53" and Cell C59="2597" and Cell D59="$45,010.53" then maybe somewhere in Column E it says match or something like that. I Really need help on the first part but if anyone can answer the second part as well then please do so. Thanks.

In cell E1 put:
=IF(RIGHT(A1,3)=RIGHT(C1,3),"Match","No Match")

If you want it to be 4 characters, replace the (A1,3) and (C1,3) with (A1,4) and (C1,4)