Forum Discussion
Excel Power Query - How to refer to different sheets of info based on value
Hi Team, I'm new to the Power Query aspect of Excel (and more broadly to the more complex side of excel), I am dealing with a situation where I need to: - Read from 1 spreadsheet, and match a c...
Craig530 You would have to connect to both sheets and then perform a merge of the two based on the item code. Since you mention to be new to PQ, it's good to learn more about its basics first. The link below takes you to a site that can do just that.
https://exceloffthegrid.com/power-query-introduction/
Scroll down towards the bottom of that page and go through the blog posts listed (1-20). Number 13 deals with your issue.