Vlookup referencing a PowerQuery table?

[AFranck]

All-

I'm running Excel 2010 & have a file setup with PowerQuery pulling in from SQL. I'd like to essentially run a vlookup from other sheets of this file to reference a few select fields of the PowerQuery results. Is this possible or is there an alternative?

Thanks!

 

[theBardd]

Create a separate query for each of those tables, and do a Join, an example is here

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Get.DeptRate = Table.Join(Source, {"Dept"}, Table2, {"Dept"})
    // delete unwanted columns
in
    Get.DeptRate