How to apply VLOOKUP in Power Query editor?

Hi Anonymous ,

In Power Query functions can be created like this:

(lookupValue as any, lookupTable as table, lookupColumnName as text, returnColumnValue as text) =>
let
// lookupTable= Products,
// lookupColumnName = "ProductKey",
// returnColumnValue = "Price",
// lookupValue = 1,
 colLookup = Table.Column(lookupTable, lookupColumnName),
 colToReturn = Table.Column(lookupTable, returnColumnValue),
 lookup = List.PositionOf(colLookup, lookupValue, 0),
 Result = if lookup >=0 then colToReturn{lookup} else "Not found"
in
 Result

Or

You can duplicate your query and merge the two queries to get the desired columns.

Disable the load from the duplicate one to avoid performance issues.

Please refer to the following documents for more information.

#PowerQuery – Replicate doing an Excel VLOOKUP in M – Erik Svensen

How to do a real VLOOKUP (false) in Power Query or Power BI – The BIccountant

VLOOKUP / XLOOKUP in Power Query - Bing video

VLOOKUP in Power Query Using List Functions - Bing video

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.