VLOOKUP in Power Query using List Functions|Power Query|Excel Forum|My Online Training Hub

Hi, I recently used the technique outlined in Phil\'s post here:

VLOOKUP in Power Query Using List Functions • My Online Training Hub

It was really helpful to me, and I have already applied it in a couple of my files.

In Phil's example file the Sales value in the Sales_Data table is looked up in the BonusRates table.
And based on this value, the bonus rate (%) is returned into the Power Query results table (Sales_Bonuses table).

Now, in this example, the field being looked up is "Sales" without any spaces.

However, in my files, I have field names with spaces (e.g. "Income (in USD)" or "Time of Record", etc.).

In such a case, the M Code gives an error because the field name includes spaces.

To replicate this error, I changed the field header from Sales to "Sales Value" in the example file uploaded on the MOTH website.

The error occurs in the M-Code line

= Table.AddColumn(#\"Changed Type\", \"BonusRates\", each let val = [Sales] in List.Select( BonusRates[Threshold] , each _ <= val ))

In this line, the field name "Sales" needs to be "Sales Value".
But I am not able to figure out the correct syntax and get the M Code to work.

I have attached the example file with this change, along with screenshots of the error I'm getting.

Please help!

~KV