Forum Discussion
Solved
How to tweek table array in Vlookup function
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 m...
Mojibure I would go for INDEX and MATCH in stead of VLOOKUP, as demonstrated in the picture below:
Of course, this assumes that the digits are always in the same spot within the larger string.
Mojibure I would go for INDEX and MATCH in stead of VLOOKUP, as demonstrated in the picture below:
Of course, this assumes that the digits are always in the same spot within the larger string.
Thank you Riny.
This looks awesome.
This looks awesome.