AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() Go to Data (in excel 2016, power query is in Data Tab, else you’ll have a separate power query tab).transactions table file) perform the following tasks ![]() In the file where you have to perform Vlookup (i.e. IMPORTANT NOTE –For performing a Vlookup, both these data sets have to be loaded as queries in the same excel file. Transactions Table (where you’ll typically write the Vlookup formula) & Source Data Table (where the search will be made) ![]() If you did not know, you can do a really fast vlookup using excel too but this post is about how can you do a Vlookup in Power Query It’s automated, you just have to do this once.Vlookup is one of the most common tasks in excel and of-course you can always write a Vlookup formula for that but doing a Vlookup using Power Query has 2 main wins
0 Comments
Read More
Leave a Reply. |