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
Bookmarks