Hello fellow Excel enthusiasts
I have a huge and very complex setup in an excel file, that now uses a combination of VBA and formulas. I would like to try to convert a lot of that into Power Query instead, but am pretty unfamiliar with Power Query.
I have tried to set up a very simplified demo sheet and would very much like a bit of help, getting started on how to add a couple of columns with lookup from other tables with Power Query.
Hopefully the demo sheet is quite self explanatory from the picture below, otherwise I will gladly give a more detailed run down on the specific columns and their expected results if needed:
PowerQuery.png
Thanks in advance
Best regards
Imbizile
Bookmarks