Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/

Short and to the point, great job. thanks!

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

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

Thank you, easy and clear instructions.

Thanks. Exactly what I was looking for!

@GoodlyChandeep

5 жыл бұрын

Glad you found it helpful.!

Very nice and to the point. Amazing!

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

Helpful..thanks 👍

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

@GoodlyChandeep

5 жыл бұрын

Glad you liked it!

Thank you. Very helpful.

@GoodlyChandeep

3 жыл бұрын

Glad you liked it

Thank you so much.

Good job dud 👍👍👍

Cool man... Doing great stuff..

@GoodlyChandeep

Жыл бұрын

Thanks!

nicely explained. thanks

@GoodlyChandeep

4 жыл бұрын

Glad it was helpful!

Great post

@GoodlyChandeep

5 жыл бұрын

Thanks Pratik, glad you liked it

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”

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

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

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

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.

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?

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!

@GoodlyChandeep

4 жыл бұрын

By 2 criteria if you mean concatenated Vlookup, it is possible. While merging the query just select the columns in the same order for both the tables and then apply "Left Outer Join". Hope that helps

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?

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

@asimkumarchakraborty2456

5 жыл бұрын

You can split first-name, middle name and last name by blank, then left outer join and again merge the column by space, simple...

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

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?

@GoodlyChandeep

5 жыл бұрын

Hi power query will take both records!

@asimkumarchakraborty2456

5 жыл бұрын

So if you want only one value then you need to remove duplicate after join, it will remove second entry if any.and for multiple value the normal procedure which is shown in video.

@GoodlyChandeep

5 жыл бұрын

@@asimkumarchakraborty2456 remove duplicates before the join

I think it can lookup first value similar to vlookup and what about for multiple lookup values of same transaction codes

@GoodlyChandeep

4 жыл бұрын

Yes it would work on duplicates too. That means that if the transaction code is duplicated, you'd receive 2 values

@raghuv7114

4 жыл бұрын

@@GoodlyChandeep thanks for your info.i had a doubt because vlookup it always give first search value.

@GoodlyChandeep

4 жыл бұрын

@@raghuv7114 PowerQuery Vlookup has the ability to deliver multiple values found! Cheers

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

@GoodlyChandeep

3 жыл бұрын

Yes but I'd recommend that you make use of Power Pivot - Relationships

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

@GoodlyChandeep

3 жыл бұрын

Dont do a vlookup. Create a relationship between 2 tables

Hello Chandeep is it possible to pick up the second value or the nth value

@GoodlyChandeep

5 жыл бұрын

The good thing about Power Query is that it will fetch all duplicates found. Nothing changes in the process. It's the same

@excel-k-sir

5 жыл бұрын

@@GoodlyChandeep thank you for the quick reply I am having a problem in removing duplicates and keeping only the latest record. When I am trying to remove the duplicates it removing as per the order in source data and not per sorting done.

Hi Guys, anyone know how to return a different value if it finds null ie no match , if you do merge and it returns null in power query how do you tell it to return a different column

@GoodlyChandeep

3 жыл бұрын

2 Ways - You can write another conditional column. - or if you know how to write M Language, in the formula bar wrap the merge step in an IF statement.