Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
142
Views
Topic starter
I was watching the Ultimate Personal Budget https://www.youtube.com/watch?v=e0oQ5N_rYU4
Once I create my Category Table (as a foundation), how can I automatically bring it to the Budget Sheet? Instead of choosing for a drop down list?
thanks
lucia
Posted : 07/01/2024 5:12 pm
Hi Lucia,
You can use formulas to add the missing details from category table (replace the placeholders with your real references).
=INDEX(Category, Match(SubCategory, SubCategoryColumn, 0))
Or, you can use power query to merge the 2 tables using subcategory and expand the columns you need from the merged table.
Posted : 11/01/2024 1:15 am