Power Query Approximate Match VLOOKUP - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 8
Iakovosian
Hi - thank you for this video. I'm much more well versed in Excel formulas, and am just beginning to get to grips with Power Query.
When would it ever be more useful or better practice to do this in PQ, rather than as a formula calculation in the original table?
e.g. such as using VLOOKUP, or even simply =MOD(MONTH(B2),4)+1 for the second example
reply
Hi - thank you for this video. I'm much more well versed in Excel formulas, and am just beginning to get to grips with Power Query.
When would it ever be more useful or better practice to do this in PQ, rather than as a formula calculation in the original table?
e.g. such as using VLOOKUP, or even simply =MOD(MONTH(B2),4)+1 for the second example
reply
Genivaldo
Congrat for you tips.
I have a doubt. CAn you help me.
When you have a row for each initial sequency it works e.g. (first day of , but what should we do in case of the row number 4 was 999. The result will be 15% instead of 10%. I dont know if I was clear.
reply
Congrat for you tips.
I have a doubt. CAn you help me.
When you have a row for each initial sequency it works e.g. (first day of , but what should we do in case of the row number 4 was 999. The result will be 15% instead of 10%. I dont know if I was clear.
reply
sarita
If I have a three name in the column like ,India,Delhi, Gurgaon .if I get filter in India column and I work .but problem is this previous value has been finished , like Delhi, Gurgaon data we could not find kindly solve my problem
reply
If I have a three name in the column like ,India,Delhi, Gurgaon .if I get filter in India column and I work .but problem is this previous value has been finished , like Delhi, Gurgaon data we could not find kindly solve my problem
reply
Wajdi
I think it will work only if exact values are found in the 2 table .. othwerwise when you merge both tables no value witth exact matching will be found and the fill in down won't work
reply
I think it will work only if exact values are found in the 2 table .. othwerwise when you merge both tables no value witth exact matching will be found and the fill in down won't work
reply
LastDance
Hi Mynda, if I were to add new snapshot data to power query each month end, would this approximate v look up trick still work on the new added data? Thanks in advance
reply
Hi Mynda, if I were to add new snapshot data to power query each month end, would this approximate v look up trick still work on the new added data? Thanks in advance
reply
Edo
This trick only works if every value has at least one exact match in the table. Is there a way of doing this in a big table where no exact matches will be found?
reply
This trick only works if every value has at least one exact match in the table. Is there a way of doing this in a big table where no exact matches will be found?
reply
Wayne
Hi Mynda. Just watched this again. Even better than the first time, now that I understand more about Power Query :)) As always.. thanks much! Thumbs up!!
reply
Hi Mynda. Just watched this again. Even better than the first time, now that I understand more about Power Query :)) As always.. thanks much! Thumbs up!!
reply
MB
I amazed with ur vids.. how can i lookup for the values in query not for single excel table/file.. for source folder.. great if you reply..
reply
I amazed with ur vids.. how can i lookup for the values in query not for single excel table/file.. for source folder.. great if you reply..
reply
Add a review, comment
Other channel videos
