You can use vlookup to look at part of a string by combining it with other Excel functions.
For example, we have a list of product codes which look like this.
In order to populate our first table with countries, we need to do a VLOOKUP on the last two letters which we’ll do using the RIGHT function. So the SearchFor part of the formula becomes RIGHT(A2,2) which means the rightmost two letters of the value in cell A2 which in this case is DE. The rest of the VLOOKUP formula is just done as usual.
=VLOOKUP ( SearchFor , WhereToSearch , WhichColumn , NearOrExact )
Resulting in the countries column of our product table being populated with countries!
Want to get good at using the VLOOKUP function?
Download our practical VLOOKUP tutorial workbook with step-by-step instructions and examples to help you become a VLOOKUP pro.