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

[HappierThan]

G'day, hope I have this right. Target B2=VLOOKUP(A2,Garage!A2:M100,10) in C2=VLOOKUP(A2,Garage!A2:M100,11) in D2=VLOOKUP(A2,Garage!A2:M100,2)

If you are concerned about having formulas in the end result Ctrl+A < Paste Special - Values Only.

[AliGW]

I wouldn't use VLOOKUP here because of the number of columns involved - I would use INDEX MATCH:

=INDEX(Garage!$J$2:$J$23,MATCH($A2,Garage!$A$2:$A$23,0))

=INDEX(Garage!$K$2:$K$23,MATCH($A2,Garage!$A$2:$A$23,0))

=INDEX(Garage!$B$2:$B$23,MATCH($A2,Garage!$A$2:$A$23,0))