mardi 23 décembre 2014

find close match from sheet 1 and sheet 2, copy to sheet 1

Hi and thank you for taking your time to help. My current issue is I need to use data from sheet 1 and compare it to data in sheet 2. If the data is close, within 4 characters, then I need data from another from sheet 2 to be copied to sheet 1. Let me try and put it into a table.



Sheet 1
A B C
Row 1 One-77 '11
Row 2 Veyron 16.4 '13
Row 3 Corvette Z06 (C6) '06
Row 4 Nova SS '70
Row 5 Enzo Ferrari '02
Row 6 NSX Type R '92


Sheet 2
A B C
Row 1 One-77 Premium
Row 2 Veyron 16.4 Standard
Row 3 Corvette Convertible (C1) Premium
Row 4 Nova SS Premium
Row 5 Enzo Ferrari Standard
Row 6 NSX Type S Premium

Sheet 1
A B C
Row 1 One-77 '11 **Copies Premium**
Row 2 Veyron 16.4 '13 **Copies Standard**
Row 3 Corvette Z06 (C6) '06 **Does Not, Leaves Blank**
Row 4 Nova SS '70 **Copies Premium**
Row 5 Enzo Ferrari '02 **Copies Standard**
Row 6 NSX Type R '92 **Does Not, Leaves Blank**


Keep in mind that in Sheet 1 the last 3 character are the model year. Those numbers need to be there. They are not in Sheet 2.


Aucun commentaire:

Enregistrer un commentaire