Hi everyone,
I have a question which im strugling with.
I want to make a data sheet where i can pull the history of a curtain asset. its as follow, attached a file as i call it airs lookup tool
The top part is made to view the current data from a hidden csv sheet inside the file which will be updated daily.
Prefferable no changes must be made on this sheet cause its copy paste as it is.
In the main sheet called showlist below the first part there are some cells which i like to see the history of a asset pulled from the csv sheet, these must contain al history of this asset which is entered in C4. How do i accomplishe this. ive tried vlookup but it doesnt do it.
any help would be appreciated. ps the original csv containes 82000 assets, so ive shortened the file a bit
The history of an asset can contain 10 til 20 lines and several dates are there from 2014 till 2008
who can help me and explain things to me how it works best
Bookmarks