How to automate files with vlookup RRS feed

  • Question

  • Hello. I have a MASTER file with dates going across the columns and two tabs, sales and impressions. Then, for each day, I have a new file for which I want to do a vlookup to populate the master file for each tab. Is there a way that I can automate this? Let's say I have 10 files for 10 separate dates. Files attached. Can I do this with power query? 

    Tuesday, January 9, 2018 2:57 AM


  • On the surface, it sounds like this should be possible. However, we would need more details (such as sample input and output, showing precisely what you're trying to accomplish) to say for sure.


    Wednesday, January 10, 2018 6:47 PM