My lookup table is like this:

LookUpTable
OLAF0009
OLAF0050
OLAF0325

The data table looks like this:

DataTable
009F0OLA
050F0OLA
325F0OLA

Can a VLOOKUP compare the last 3 characters of the data table with the first
3 characters of the lookup table ?

Thank you in advance.