Power Query Functions -- LookupValue or vLookUp equivalent

[learning new things]

I am fairly new to Power Query and I am trying to create a function that looks up a specific field and returns the value of an associated column (basically like a vlookup function) to be used in a custom column function.

From what I have found there seems to be no Power Query (M) code function to this, so I need to create my own. Is that true? I am not just merging tables, but trying to use a lookup value to feed a variable in my custom column function.

I appreciate any insights or guidance on how to handle this problem. I am trying to avoid creating parameters to which I have to add information into that already exists in one of my default tables in the spreadsheet. Seems redundant and a prone to errors if I duplicate that effort.

[CK76]

There is way to do it. Though there is no direct function like VLOOKUP.

There are multiple ways to accomplish this. But without knowing your data and what exactly you are trying to accomplish...

It's rather difficult to give you the solution. Please upload sample workbook with sanitized data, with about 20 ~ 25 rows that accurately represent your actual data set.

[sandy666]

set lookup_value cell as table
set range of data as table
load both as queries
merge lookup_value query with data query by appropriate column

any example?