PQB13: PowerQueryBasics: 2-dimension search using Formulas (Vlookup+Match) & Power Query

Excel Data Analysis Series: PQB “Power Query Basics”
PQB13: 2-dimension search using Formulas & PQ
Search for a value in table: using 2 criteria
Using Formulas: V-lookup () + Match()
Using PQ: Unpivot column + Merge (left outer)

To download the excel file:
https://drive.google.com/open?id=14V7Hsa82gd9r1iMBpTuysKyHXCzLFhDR

To watch video PQB09:
https://youtu.be/H1wVf-orhlI

To watch the full playlist
https://www.youtube.com/playlist?list=PL5NlUYOM2iOhZOJL_GM6zNd2k9-IEqmaV

To subscribe to the channel:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

To follow on Facebook:
https://www.facebook.com/excelispower

To follow on LinkedIn:
https://www.linkedin.com/in/amratef

Видео PQB13: PowerQueryBasics: 2-dimension search using Formulas (Vlookup+Match) & Power Query канала AAA Excel’s Power