Approximate Lookup in Power Query

[earthworm]

Is there any easy way to apply vlookup or merge column in power query using approximate match . I search through google but its too complicated.

 

[GraH]

The easiest way I know that often works is.... Appending data.

Say you want to look a tax rate based on income and in your lookup table you'd have gross income as a reference threshold.
It's a matter of naming both columns alike.
Once appended, you can sort the table on the "lookup column", fill down the "looked up values" and filter out null values on one of the columns that's not in your lookup table.

One scenario where things might brake, is on text values with accented letters, as the sorting will not group them together. For example, if é,è or e all need to be treated as "e", then there is some clean-up required too.