Vlookup in PowerQuery

Learn how to perform a Vlookup in PowerQuery.

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[Officialmotive]

Perfect, exactly what I was looking for. Thank you!

[drdavescomputing]

Thank you, easy and clear instructions.

[rameshpotti]

I understand thoroughly, it is precise and to the dart. Perfect !!!

[atifmir]

Nice and to the point. Now i know how to do vlookup in power query. Thanks!

[qobla_worgbah]

In merging the queries, I realized it messed up the order of the transaction codes.How can you ensure the merging does not change the arrangement, especially if the corresponding value is “null”

[BharathirajaNarendran]

Thanks. Exactly what I was looking for!

[diocarcruz]

Short and to the point, great job. thanks!

[aiswaryasanthosh]

@GoodlyChandeep
How is ur power query so fast
Mine is taking ages for each step to load

[putrapurnamasesa]

Thank you so much for tutorial.. I want to ask about, How First table vlookup to second table if second table have two or more data. For excemple, first table have field id customer "001", and the second table have field id customer "001" and second field Job "Docter" and "teacher". IF second table have 2 of Job for id costumer "001", power query will take data wich one?

[EashwerIyer]

I want to do the vlookup in my target table not. just looking at the source data, but with additional condittion tthat thte date condition falls between 2 dates in the looked up tablee

[vaidshreesable]

Data search in power query but not give out put, pls help us error show in no more 999+ row

[vijaykandasamy]

Is possible to use power query instead of vlookup in case if the data table has repeated values?

[michaelkristensen]

Hi Thank you, I have quistion. My data file / secondary file contains 64785 lines of data and I am only interested in the match, who or what can i do here? When i follow this eks. I do get the matches but also all other items numbers.

[booneellis]

Is it possible to use the merge in Power Query to do a vlook up with two criteria? I've done them using a helper column in the look up table and writing A1&"l"&B1 in the value part for the vlook up formula. Thanks!

[safiya]

how to save the query and resultant excel sheet as in the same file, I did with csv format, previous contents, queries gone, what is the solution?

[ramkumarscn]

Really appreciate.. Thank you so much for this video.

[raghurao]

This is really awesome, but how to use partial Vlookup in power query... Let's say, in a cell it has full name 'Ranjith Singh' and I need to Vlookup in other table which only has 'Ranjith' and need to find his salary. Pls help how to run this in power query

[ryanpeterson]

why do i get the following error "DataFormat.Error: We couldn't convert to Number. Details: 176.1.CAP" Both Columns referenced were formatted as numbers "1.2 type" to return a text value field. I have tried to format both number fields as a text to pull and still no luck. Can anyone explain?

[MrVijendra]

I have 20lacs of data in excel firstly how should I import in power query and how can I do vlookup in two large files in vlookup

[shyamnair]

Can this be used in case of a excel file having more than 10-15 different vlookups from other excel file?