Vlookup formula not working

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,

The * character in the lookup ctiteria is used as a wildcard character, you need to cancel the wildcard functionality to make it work.

=VLOOKUP(SUBSTITUTE(A7,"*","~*"),$A$2:$B$3,2,FALSE)

Dear Richard and Jason
Good evening
Thank you very much for your help. I have other special characters like ],/ along with * will this formula will work for all special characters? when i use star as wild character excel considering all to retrieve data and this is making problem for me. you formulas working fine with example data but it is not working good in my real data.
Thanks in advance
Regards,

Thank you very Jason.B75 for your valuable help and suggestion towards my problem

You're welcome!
Thanks for the feedback.

I just noticed a typo in the formula, I've edited my original reply to correct it.