Tag Archives: Merge Query

#PowerQuery makes advanced VLOOKUP so easy!

Do you use VLOOKUP?  If you do, you should know there are limitations of VLOOKUP.  Also there are some cases VLOOKUP is not straightforward and efficient. Consider the following cases: What we want to achieve is to map the corresponding … Continue reading

Rate this:

Posted in Power Query | Tagged , | Leave a comment

Maintain a price book in #Excel with #PowerQuery

Feel the Power (Query) This is my first post devoting to my recent love for Excel – Power Query.  🙂 First, let me make myself clear.  I am still learning Power Query (indeed I am still learning Excel too).  The … Continue reading

Rate this:

Posted in Power Query | Tagged , , | 2 Comments