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.
<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.
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.