Ranged vlookup?

[j0shuajacks0n]

--A----------B----------C----------D----------E----------F----------G----------H
Start-------End--------Min--------500-------1000-------2000------3000-------4000
76054-----76099-------0.35-------0.33-------0.31-------0.29-------0.25--------0.22

I am looking to build some kind of vlookup where if a number that is equal to or between columns A & B, will return the values in C, D, E, F, G, and H. "If" statements will work, however I have over 17,000 lines that have this same situation above. I can build it if the number is in either column OR column B, but not between. Any help is much appreciated!

 

[iliace]

What if you have multiple matches? Meaning, a number falls within more than one row of A:B range?

 

[j0shuajacks0n]

That situation won't happen. SInce they're all zip codes, they will only be associated with one row.

 

[j0shuajacks0n]

Bump