Partial Matching and copying over a separate column when a match is found

[sco315]

Hello. I have two columns I and J that have some model numbers in them. Model J has model numbers that are longer than those in column I. I want to have another column F that looks at I2 and searches column J for a partial match (7 characters) and once it finds one, it copies the date from column K into that new column.

New Date (F)	Model #(I)	New Model #(J)	Old Date(K)
	16AKU48	12AJO30	4/19/2015
	BLS2I78V0N	TBAB-335-2N	6/30/2013
	11AI249	RCSL-O*4251	8/13/2014
	HDF48*G56	SADE-042JA	9/7/2015
	OM89-KK9	16AJL48A01	2/18/2013
	BP017-59111	11AI249OP9	12/21/2011
	354ASI	RIFA-98710	11/17/2013
	RPPE-F456	18AMYE16	10/15/2014
	4HGP*56ER5	41SUQ160193L	6/10/2015

<tbody>
</tbody>

So in this example, the code entered in F4 would look at I4 (11AI249) and search all of column J until it finds something that matches the first 7 characters to I4. Once it does (J7) it copies the date adjacent to it into F4.

If someone could please help me, I would greatly appreciate it. All I have so far is =MATCH("*"&LEFT(I2,7)&"*",J2:J464,0) but that is very wrong.

 

[Maverick27]

Download & install the "NEW" Excel Fuzzy Lookup Add-in. Works like a charm - no coding required.

https://www.microsoft.com/en-us/download/details.aspx?id=15011

 

[sco315]

I appreciate the suggestion, but unfortunately it needs to be coded. The columns are actually being populated from other files and the new dates will need to update themselves whenever I open this spreadsheet too.