find location of inventory based on data input

[casey hargis]

I have an inventory of Vehicles containing data such as: vin, Location, Arrival date and time.
A = Vins B= Locations C=Blank D= Blank E=List of vins for input(match to A) F= Locations to pull from B

I would like to be able to input a column of Vin numbers, have those vins matched to the original column of vins and pull the locations of the vins into an adjacent column.

What is the best way to go about this? I'd like to be able to use this daily to quickly pull lists together of vins.

Thanks

 

[rahulshewale1]

hii @casey hargis ,


Could you please share sample file with desire output ?


Regard
Rahul shewale

 

[casey hargis]

Here you are. @rahulshewale1

 

[rahulshewale1]

Hii @casey hargis,

see if is ok ?
=IF(D2="","",VLOOKUP(D2,$A$2:$C$8316,3,FALSE))


Regard
Rahul shewale

 

[casey hargis]

Hi @rahulshewale1,

It seems the data deletes itself and does not alway return location with the way that is formatted.

Unfortunately, that formula does not seem to be working for me.
the number of input vins could be 1-9999999 just depends on how many I need to find. I'd like it to place the location next to the correct vin.

thanks

 

[Peter Bartholomew]

Power Query might be the best environment to support the import of fresh data and extraction of a sub-list. It seems that any lookup [join] in PQ will be associated with a sort to make it efficient, so you might need to insert an index column, perform the join, re-sort by index, delete the index, close and load.