j0shuajacks0n
New Member
- Joined
- Jun 6, 2008
- Messages
- 5
--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!
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!