VLOOKUP in Power Query Using List Functions

Microsoft Excel Tips and Tricks

Using List functions in Power Query to do Exact Lookup and Approximate Match Lookup is faster and easier to create than using table merges.

Credit MyOnlineTrainingHub