How to tweek table array in Vlookup function

Copper Contributor
I want to apply Vlookup but lookup value is 314-645 and table array's first column has value GHJ-314-HTY-645-KPU
Now how can I tweek table array'first column data in formula itself because I cannot make change in table array sheet. This is use of very frequently so this takes lot of time if i copy table somewhere else and make changes into it.
Please suggest solution
Thanks in advance.
1 Reply
You have posted on the Microsoft Learn community board which is all about exams, certification and training. You might get a better response on the Excel community board