VLOOKUP is one of the most commonly used functions in Excel. However, it comes with its own set of problems:
- It increases the file size
- It consumes lots of processing power, making things slower
- It is limited to a single table. This means you cannot use VLOOKUP to search for a value in a different table or sheet
- It only looks right
- It can only handle a single criteria
- If the lookup column contains duplicate values, it will match the first value only
With Microsoft’s Power BI, we now have a simpler and better alternative to handling VLOOKUP limitations using Relationships. Watch this video to learn more:
Power BI Udemy Course coming very soon
This video is one of 30 lectures in my soon-to-be-released Power BI course on Udemy. It is my first ever course in the e-learning space. I am currently working on the last lecture, and the course will be released in a matter of days. Watch this place for further announcements.
