I have a price list Excel workbook & sales data workbook. In this video, let’s combine these two files using Excel.

In the video…
===========
0:00 – File connection problem
0:53 – Using formulas to link two files
1:38 – The problem with formula approach
2:14 – Another way to connect two files (Power Query)
3:49 – What happens when you have new data?

Sample files:
===========
Sales data file – https://chandoo.org/wp/wp-content/uploads/2022/03/Sales-Data.xlsx
Price list file – https://chandoo.org/wp/wp-content/uploads/2022/03/Price-List.xlsx

Curious about Power Query? Learn more from these videos
===================================================

Complete & in-depth video on Power Query (80 minutes) – https://youtu.be/PiFAa_jjaEI
How to combine multiple Excel files – https://youtu.be/SGzegma9bdY
How to combine multiple worksheets to one data set – https://youtu.be/k_ugshJ4wIw
More Power Query videos (playlist) – https://www.youtube.com/watch?v=PiFAa_jjaEI&list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2

Want to learn a LOT of Excel in ONE PLACE:
===================================
I run a comprehensive & step by step Excel course that is 100% online & self-paced. If you want to learn Excel for data analysis or reporting work, then this course is must have. Check out https://chandoo.org/wp/excel-school-program/ and sign up today.

~ Have a beautiful day

Please take the opportunity to connect and share this video with your friends and family if you find it useful.