Vlookup to results of Formula with numbers and letters.

[FernTurpin]

Hi All. Looking for help.

I start off with a sheet that has a list of VINS. Call this list Target (this list will change every month)

I need to compare that list of VINS and get data from multiple columns in a master list of Vins. – Call this list Garage

So, I am trying to do a Vlookup to allow me to compare each line in TARGET and find the corresponding entry from GARAGE and show additional data from Garage.
(Note: A VIN CANT be in Target if it is not in Garage)

Problem is, the cell I am using in Garage is a formula that takes the last 8 characters from one of the fields (VIN)
See file.

Tab Garage Full Database
Tab Target List of Vins that I need the following info
Sold To
Associate ID
Stock #

Hope this makes sense.


Thanks