Hi
=VLOOKUP(lookup_value,A1:B10,2,TRUE)
--
Regards
Frank Kabel
Frankfurt, Germany
"Confused" schrieb im Newsbeitrag
...
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!
|