For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables
Please note that I have received feedback on the performance with this technique, as slow.
I have used it with small data sets like in the example that I presented, and works fine.
But, please keep that in mind.
Thanks for watching 😊
Working file is available here:
https://drive.google.com/drive/folder...