How to do an "In-between" lookup

[Nismodr]

Hello all. I'm stuck on a problem, and hoping someone can help me out. I have a large csv file that I am trying to join to an xlsx. In the xlsx I have an ID number. In the csv I have a lower range of id numbers in one column, and an upper range of id numbers in the next column. I need to join the files where the xlsx id is in between the csv lower and upper columns. For example:

csvLowerNum   csvUpperNum   xlsxId
1             10            5    

Any ideas?

[neilgallen]

@Nismodr there are a number of different ways to accomplish this. Can you possibly provide either the source files or a sample of the source files? That's the best way to get the simplest solution for you.

[BenMoss · Accepted solution]

@Nismodr take a look at the 1st weekly challenge and some of the responses here.

It's basically the same problem as what you have identified.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-1-Join-to-Range/td-p/36621

Ben

[Nismodr]

Awesome, I should be able to figure it out the rest of the way from here. Thanks!