Using vlookup for partial lookup value

%3CLINGO-SUB%20id%3D%22lingo-sub-2274674%22%20slang%3D%22en-US%22%3EUsing%20vlookup%20for%20partial%20lookup%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2274674%22%20slang%3D%22en-US%22%3EIf%20lookup%20value%20is%2023A%20and%20I%20want%20to%20lookup%20only%2023%20from%20that%20and%20return%20the%20corresponding%20value%20against%2023%20from%20the%20data..%3C%2FLINGO-BODY%3E
Occasional Visitor
If lookup value is 23A and I want to lookup only 23 from that and return the corresponding value against 23 from the data..
1 Reply

@Japsq 

Will it always be the first two characters? Or all digits, however many there are?

And do you want to look for "23" as a text string, or for 23 as a number?