VLOOKUP and other lookup functions are frequently used to combine data in a new table. This could drastically enlarge the Excel sheet and slow it down.  

GOOD NEWS! VLOOKUP is dead! You will not need to use it any longer! 

Take advantage of Power Query’s revolutionary functions and be more productive in work! Do yourself a favour and learn this simple but revolutionary method of comparing and combining data from 2 tables in Power Query! Thankfully, it is time to forget all those huge excel functions and focus on modern way of combing & audit data! 

For more videos like this Like our video and subscribe to our YouTube channel 🔔