Hello, my problem is analogous to the following: I also have to VLookup something that is repeated, using those same tables. Tldr: have to compare databases with VLookup, but the names in my database are incomplete (in relation to the data base I have to compare it to) and dont follow a pattern. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.You’ll see the transactions table will be loaded in the query editorįinally its time now for Vlookup. Click anywhere in your transactions table.Remember I mentioned that both data sets have to be loaded as queries in the same excel file You’ll see the query will be displayed in the Query’s Pane Then in the Home Tab click on Close and Load To.You’ll see all the data gets loaded in your query editor, I have additionally given a better name to my query (i.e.Select the sheet (in this case – Sheet 1) in which contains the data and hit on Edit Import the source file (in this case – Data) in the Import Box

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

Learning vlookup in excel 2016