Apr 01 2022 09:55 PM
Apr 01 2022 11:04 PM
Solution@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.
Apr 01 2022 11:12 PM
Apr 01 2022 11:04 PM
Solution@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.