It really does help if we can be given the formula that is giving the
problem

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Confused" wrote in message
...
I used VLOOKUP in a spreadsheet some time ago, where I had the column set
to
assign a rating based on results. When I used it previously, it returned
results based on the number in the column being the HIGH end of the range
for
each rating.

Example
10 - Rating 1
25 - Rating 2
50 - Rating 3 and so on.

So, anything that fell between 26- 50 would be in Rating 3.

This time it is using the number in each rating as the START of the range.

I used a QUARTILES function to come up with quartiles for a group of
numbers, and it appears to pick the high end number for each quartile. I
tried using the VLOOKUP to assign the correct Quartile to the
lookup_value,
but it is not working out as it should.

Does anyone have ideas for what I am doing wrong, or for a better way to
assign quartiles to a group of numbers?

Thanks!