Thank you so much for this well explained, well taught video. I have spent days trying to figure out why my VLOOKUP formula is not working between two worksheets. Not only did you solve my problem, you relieved my stress and frustration so much, I literally teared up when the power query did exactly what I wanted it to do with VLOOKUP by following your instructions. I really can't thank you enough. I will subscribe to your channel to show support.
I was able to grasp this easily since I'm familiar with bith Excel and sql.. just wondering what it will be like for people to learn this without sql knowledge
Great one. One doubt. The table is not getting refreshed when I change data in the source workbook? Could you please do a video wherein the table gets refreshed
Can you please provide the excel worksheet for our hands on and practice? It is very difficult to learn it just by watching and not able to practically do it?
Please provide full tutorial on power queries in Excel worksheet or PDF format with images to better understand,how to use it complete tutorial on power queries thanks
If i have 2 sheets in same excel file which have take example order id's but are not matching cell to cell, how can i get them matched to check if any particular order id in one sheet is not matching with the order id's in other sheet
I am using "Microsoft Office Professional Plus 2016" 64 bit on Windows 7. After I click Close and Load, the final table has only Sheet1, Sheet2 and Sheet3. Sheet4 is not there. Sheet 1 is blank. Sheet 2 has all the columns of Sales_Table and one column in the LookUp table. Sheet3 has the lookup table. How do I get Sheet4 to appear ? Perhaps Office 2016 version do not have sheet4 ?
Will this work if the original sources are power queries? Will the refresh function still work from the output sheet, to refresh the original power queries? This seems like exactly what I've been looking for, but this may be the only catch. I suppose I could do the same inside of one sheet and just hide the sheet tabs of the original queries also, to keep it all within one sheet also, just by saving the power queries to files...?
I have a situation where i use IFERROR(VLOOKUP between two excel files. If the vlookup result is not found using the primary key then i use the secondary key to lookup. Can you help me how to do this in PowerQuery?
Sir, while practicing of these Initialisation of the data source failed. error coming. And data not uploading completely. Also not showing the icons like ABC etc in filters cells. Could you please suggest.
A=118 B=1.3 C=84 D=89 E=0.94 F=0.08 G=0.38 H=WRONG A=RANDBETWEEN (117,151) B=RANDBETWEEN (10.8,13.4) C=RANDBETWEEN(D-20,D+20) D=RANDBETWEEN(68,92) E=C/D F=((0.48*B*((A)/E)/1000)) G=(6700-(5*25))*F*((1/(500-25))-(1/(800-25)))*0.9 THIS FORUMULA, I have given in cells BUT I REQUIRE F 2.220 H= IF(AND(F 2.220),"OK","WRONG") IS IT POSSIBLE, PLEASE GUIDE ME HOW TO DO
Get Certified in Advanced Excel (Power Query):bit.ly/3LdiidF
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
He never used words like "Comment" OR "Like" OR "Subscribe" in his videos. That's the reason why I like his content!
Thank you so much for this well explained, well taught video. I have spent days trying to figure out why my VLOOKUP formula is not working between two worksheets. Not only did you solve my problem, you relieved my stress and frustration so much, I literally teared up when the power query did exactly what I wanted it to do with VLOOKUP by following your instructions. I really can't thank you enough. I will subscribe to your channel to show support.
I am a power BI user and this us very helpful in power BI. Instead of using DAX of Lookupvalue in power BI. Always use Merge queries
your videos are one of the best one in indian accent . easy to understand
You did a great job presenting this merge tutorial👏
I was able to grasp this easily since I'm familiar with bith Excel and sql.. just wondering what it will be like for people to learn this without sql knowledge
never seen like this explaination 💊🙏
Very well explained, clear and concise. Thanks for the video, helped a lot. Power query is such an amazing tool 👍🏻
You are awsome Sir.. Very simple
Where is the practice material sir I want to practice whatever you taught us regarding power query..
co-asking
Well Explained method...
Dude thanks a lot, I was stuck with this for hours 😭😭😭
sir,very useful video.
please provide excel sheet in the description for practice purpose.
Well organised Advanced Excel tutorials !! Clear and crisp explanation. Thanks a ton!
Thank you!
Thank you so much for such a beautiful tutorial, Have a nice day 👍🙏🙏🙏🙏
Thanks for vital information
Vet Useful
Thank you indeed.
Awesome 😎 Teaching Sir 🙌
Thank You For sharing Knowledge. Its really Useful.
Nice job. give excel files in the description video
Super Tutorial and explainng the way is superb
great
thanks
Awesome 👍
Thanks
great!!! than kyou for explanation!
really helpful
thank you so much bro, you are really explaining the content from a listener perspective.
Excellent sir
You are doing a great job. Thank you very much. Though I am a late comer from Bangladesh.
Excellent explanation. Thanks and keep on the good work !!! Greetings from Spain.
Very good explanation, it helps me to understand 👍
Very nice video.. Thanks for making🙏🏻🙏🏻
Hey, Thanks a ton for the learning. I would request you to keep oldest to newest library to get structured learning series.
Thank you -- Thats Awesome
Thanks. Can you please provide the excel sheet that you used for practise.
Brilliantly done
Thank you bro..very nice
Great one. One doubt. The table is not getting refreshed when I change data in the source workbook? Could you please do a video wherein the table gets refreshed
Nice explanation but where file to practice
Hey bro,,, you are simply awesome
Amazing
gREAT EXPLANATION
If one has a handle on the shortcuts, one can do the needful with vlookup in a tenth of the time
Pls which version ofexcel are you using for this tutorial?
Thanks for sharing...
Sir, could we use this for a bank reconciliation statement?
And also request to create Excel worksheet or PDF format with images to better understand power bi thanks
Can you please provide the excel worksheet for our hands on and practice? It is very difficult to learn it just by watching and not able to practically do it?
Please provide full tutorial on power queries in Excel worksheet or PDF format with images to better understand,how to use it complete tutorial on power queries thanks
Nice..👏
Thank you Sir...
❤❤❤save life
Please allow us to use these resources files for practise!!
thnaks sir
great
If i have 2 sheets in same excel file which have take example order id's but are not matching cell to cell, how can i get them matched to check if any particular order id in one sheet is not matching with the order id's in other sheet
If I want to practice for this, how can I download your excel file 📁📁?
Sir can we use power query instead of Vlookup why in interviews they are looking for Vlookup only?
I am using "Microsoft Office Professional Plus 2016" 64 bit on Windows 7.
After I click Close and Load, the final table has only Sheet1, Sheet2 and Sheet3.
Sheet4 is not there. Sheet 1 is blank. Sheet 2 has all the columns of Sales_Table and one
column in the LookUp table. Sheet3 has the lookup table. How do I get Sheet4 to appear ?
Perhaps Office 2016 version do not have sheet4 ?
I think vlookup is more easy than its too lengthy excerise
Excellent but Kindly help for file
new query is not visible for me in data. please help
Will this work if the original sources are power queries? Will the refresh function still work from the output sheet, to refresh the original power queries? This seems like exactly what I've been looking for, but this may be the only catch. I suppose I could do the same inside of one sheet and just hide the sheet tabs of the original queries also, to keep it all within one sheet also, just by saving the power queries to files...?
Hello, i have one issue, in my query at the time of merging for duplicate base it is creating three raws , can u please explain
I have a question on excel report but how to contact you
Hii...
I have questions,
After getting the new sheet if we delete the another two sheet so it will impact the result sheet ...?
only 2 queries we can add in to power query or more
I have a situation where i use IFERROR(VLOOKUP between two excel files. If the vlookup result is not found using the primary key then i use the secondary key to lookup. Can you help me how to do this in PowerQuery?
Is it working only for data in table form of excel?
I didn't get edit option when i selecting the table in navigator
Sir, while practicing of these Initialisation of the data source failed. error coming. And data not uploading completely.
Also not showing the icons like ABC etc in filters cells.
Could you please suggest.
Merge is increasing rows count and values are changing, how to fix it?
Don't you think vlookup is more easy as it has less steps?
Replinsta error I m getting
Sir plz hindi me btaiye
🤘
A=118 B=1.3 C=84 D=89 E=0.94 F=0.08 G=0.38 H=WRONG
A=RANDBETWEEN (117,151)
B=RANDBETWEEN (10.8,13.4)
C=RANDBETWEEN(D-20,D+20)
D=RANDBETWEEN(68,92)
E=C/D
F=((0.48*B*((A)/E)/1000))
G=(6700-(5*25))*F*((1/(500-25))-(1/(800-25)))*0.9
THIS FORUMULA, I have given in cells
BUT I REQUIRE
F 2.220
H= IF(AND(F 2.220),"OK","WRONG")
IS IT POSSIBLE, PLEASE GUIDE ME HOW TO DO
Brilliant 👌