I wonder if you can help me.

I am trying to use VLOOKUP to do the following:

- I have a two column table, the first has words in it and the second has
percentages.
- What I want to do is lookup values (from a variety of different cells) and
match them to the percentages column - but bring back the words in the first
column.

The problem is that the values will not be an exact match - as basically the
percentages column is a list to define the ranges (i.e. it would say in the
first column a quarter and then the second column would say 24%-26%).  What I
have done is entered "a quarter" twice and then put 24% in one and 26% in the
other (to define the range).

I need a formula though to pick up the relevant match.

Thanks.