Dynamic range

[Hamder83]

Hi 

How do I solve this:

lets say I have a post code mapping files.
1 - 100 - Zone 1 
101 - 200 - Zone 2 and so on.

Then I wanna add my input data that has a postalcode 75 - then it add's Zone 1 to that row.

Without having to do a join and then a filter... because i have millions of input rows and hundreds of mapping rows.

?

[Hamder83]

I will diffently take a look into that 🙂 

I tried added some real data of mine, where I have a input data with a weight.

And a price agreement where I wanna add the correct price - depending on the weight interval.

But I cant even manage to change our macro to use my new inputs? 

Sorry for taking so much of your time, acuatly thought i knew better than this 😕

[Hamder83]

hi @DawnDuong 

May I ask you to take a look at my previous msg, if you have a few mins at some point?

I'm sorry, it seems like such a good solution, but im not even skilled enough to make it work on my acual data :'(