I have a spreadsheet that has a set number of ranges for each row. It looks
something like this:
col1 col2
1-100 $$$$
101-200 $$$$
201-300 $$$$

In another part of the spreadsheet I have a range of data containing dollar
amounts. The data looks something like this:
col5
99
127
299

What I want to do is to read through the column in this data and place the
amounts in the correct range. So for this example the value in the first
cell in col5 is 99, so it would go in the column with the range of 1 - 100.
It would read through the value ranges until it found a valid range.

I hope I am explaining this correctly. Any help would be great. Thanks