Basically:
I have 25000 articles with a inventory value in one file
I have 1700 articlenumbers in a second reference file.
I want to match and find these reference articles and retrieve its inventory value from the first file.
Data-file
Article Number Value 54 3 985 5 49000 9 4387 13 3678 1 ... ... Article 25000 87
Reference-file
Article Number 985 54 4387
Result-file:
Article Number Value 985 5 54 3 4387 13
I dont know a hole lot about excel but after a bunch of searching I found something called VLOOKUP.. is this what Im looking for?
VLOOKUP(Data-file, Column A ; Reference-file, Column A)
I hope this is not one of those standard-basic-basic questions that is asked and answered all the time but I have really been looking around for a solution.
Coolest option would be an online tool where I could just choose both files and get a third
Tnx in advance!
Bookmarks