Group index with M language and group index with R. Highlight all the code in that window and replace it with this yes its not short let pqVLOOKUP lookup_value as any table_array as table col_index_number as number optional approximate_match as logical as any. TableAddIndexColumn TableFromRecords CustomerID 1 Name Bob Phone 123-4567 CustomerID 2 Name Jim Phone 987-6543 CustomerID 3 Name Paul Phone 543-7890 CustomerID 4 Name Ringo Phone 232-1550 Index Example 1.
The power Query merge option is the alternative way of fetching data from different tables.
VLOOKUP matches values from a column and then return the values from the same row of the different column or from the same column. Here is 2 solutions. VLOOKUP matches values from a column and then return the values from the same row of the different column or from the same column. To learn more about functions and how they work in an expression see Understanding Power Query M functions.