Hi to all
Good Afternoon
I have data like this
CR86404*7*2*1*1*1*1*1*1R/CR24]*1*1*1*1 IN-18W-5-01210
CR86404*7*2*1*1*1*1*1*1 IN-18W-5-02549
in another sheet or column i am trying to IN code vlookup for these two
CR86404*7*2*1*1*1*1*1*1R/CR24]*1*1*1*1
CR86404*7*2*1*1*1*1*1*1
but i am getting same code only IN-18W-5-01210 for both the two entries but i wish to get like this
CR86404*7*2*1*1*1*1*1*1R/CR24]*1*1*1*1 IN-18W-5-01210
CR86404*7*2*1*1*1*1*1*1 IN-18W-5-02549
I do not know why vlookup is giving this type of results i tried combination of vlookup and substitute functions still no success. I really need help to solve this.
any help in this regard is highly appreciable. Please find attached file for better understanding
Thanks in advance
Regards,
Bookmarks