Can anyone please help me on this?
I am trying to validate the source data in 3 columns BU - Act - Dept in the Range validation Data [BU - Beginning Act - End Account - Beginning Dept - End Dept] (screenshot attached).
BU is a single column in validation table but Act & Dept columns are range columns. I need to check if the BU - Act - Dept combo exists in Range data. So does Power query has any functionality to validate the source data using a nested join? This needs to be done in Excel power query and not formulas because the validation Range file has more than 1 million records.
Please note that Excel Power query is free excel addin which acts as a back end database for Excel.