Hi Nick,

I had some doubts on this range lookup. I had once a reqt for range look up.

Initially i had implemented the similar logic of joining 1 col from source to one of the cols in the lookup table. it had given me wrong values.

Later i had to have 2 columns in the source linked to the lowerlimit col and upper limit col. The 2nd col in the source is a copy of the first. And in the advanced tab, i had written the query similar to yours. it had worked for me.

Can u confirm mapping 1 col from source to lookup table will definitely work.

Vvek