How can I find the range in which is cell falls when the ranges are not continuous?

[an78633]

In Tab 1 i have a list of individual 5-digit codes. Each code is a specific type of hospital procedure. In tab 2 I have a list of hospital procedures names and the ranges of 5-digit codes that fall into that procedure. The ranges are NOT continuous and have gaps in them. For example, one procedure might include all codes between 69600 - 69900 and the next might include all codes 70215 - 71005. I have 184 different procedures, each with its own range of codes. I need to look at the individual codes that I have in tab 1 (over 50,000 of them), determine which range of codes the individual cold falls into, and pull back the corresponding procedure name. However, since the code ranges are not continuous and there are gaps, I'm having trouble figuring out how to pull back the correct name for the individual code. Is there a simple way to do this?

 

[DanteAmor]

In Tab 1 i have a list of individual 5-digit codes. Each code is a specific type of hospital procedure. In tab 2 I have a list of hospital procedures names and the ranges of 5-digit codes that fall into that procedure. The ranges are NOT continuous and have gaps in them. For example, one procedure might include all codes between 69600 - 69900 and the next might include all codes 70215 - 71005. I have 184 different procedures, each with its own range of codes. I need to look at the individual codes that I have in tab 1 (over 50,000 of them), determine which range of codes the individual cold falls into, and pull back the corresponding procedure name. However, since the code ranges are not continuous and there are gaps, I'm having trouble figuring out how to pull back the correct name for the individual code. Is there a simple way to do this?

You could explain with real data what you have on each sheet and the expected result.