Vlookup in PowerQuery

Подписаться 92 тыс.

Просмотров 34 тыс.

50% 1

Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
Learn how to perform a Vlookup in PowerQuery.
Read the complete tutorial at www.goodly.co.in/vlookup-in-p...
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog

Опубликовано:

30 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 53

@GoodlyChandeep 9 месяцев назад

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

@diocarcruz9490 4 года назад

Short and to the point, great job. thanks!

@rameshpotti4551 2 года назад

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

@Officialmotive805 7 месяцев назад

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

@gladwindsouza4448 4 года назад

Very nice and to the point. Amazing!

@drdavescomputing 4 месяца назад

Thank you, easy and clear instructions.

@atifmir7409 5 лет назад

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

@BharathirajaNarendran 5 лет назад

Thanks. Exactly what I was looking for!

@GoodlyChandeep 5 лет назад

Glad you found it helpful.!

@muraliprasath99 3 года назад

Thank you so much.

@shrutichandan8344 2 года назад

Helpful..thanks 👍

@ramkumarscn 5 лет назад

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

@GoodlyChandeep 5 лет назад

Glad you liked it!

@vijaykandasamy 4 года назад

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

@MarioYouTube1 4 года назад

Thank you. Very helpful.

@GoodlyChandeep 4 года назад

Glad you liked it

@michaelkristensen1031 3 года назад

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.

@booneellis3404 4 года назад

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

@EashwerIyer 3 года назад

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

@aiswaryasanthosh7878 4 месяца назад

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

@qobla_worgbah 4 месяца назад

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”

@hernanperez912 3 года назад

Good job dud 👍👍👍

@pratikfutane8131 5 лет назад

Great post

@GoodlyChandeep 5 лет назад

Thanks Pratik, glad you liked it

@yogeshpore6725 Год назад

Cool man... Doing great stuff..

@GoodlyChandeep Год назад

Thanks!

@pkjksk 4 года назад

nicely explained. thanks

@GoodlyChandeep 4 года назад

Glad it was helpful!

@safiya1779 3 года назад

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?

@ryanpeterson7998 2 года назад

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?

@shyamnair1478 3 года назад

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

@vaidshreesable4593 6 месяцев назад

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

@raghurao191 5 лет назад

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...

@excel-k-sir 5 лет назад

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.

@raghuv7114 4 года назад

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

@putrapurnamasesa1932 5 лет назад

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

@jastottenham589 3 года назад

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.