Item1 | Item2 | Item3 | N1 | N2 |
B | C | D | XX | MM |
C | A | A | YY | NN |
A | E | D | WW | OO |
A | B | C | ZZ | PP |
<tbody>
</tbody>
Item_Name | F_Name | L_Name |
A-B-C | ZZ | PP |
C-A-A | YY | NN |
B-C-C | XX | MM |
A-E-D | WW | OO |
<tbody>
</tbody>
I have a data which is the Table-1 in one sheet and in another sheet i have a data With Table - 2 only Item_Name
column has a data, I need to fill the F_Name and L_Name column data by spilting the values in Item_Name and
comparing with Item1, Item2 & Item3 if all the three values match return the N1 and N2 coulmn values to F_Name and L_Name for that particular Item Name
Last edited: