On Sun, 28 Aug 2005 08:35:02 -0700, KDD wrote:

Thanks Ron.

Need some more clarity..

VLOOKUP does not seem to recognize "500-599" as a number and therefore is
not co-relating "500-599" with median as 750

Probably the lack of clarity is due to my misunderstanding your specifications.

What I thought you wanted to do was given some number, return the bin into
which it was slotted. If the number was, for example, 700, that would go into
the bin labeled "500-999".

I don't understand why you require the label "500-999" to be a number.

The formula I gave you, given 700 in G1, would return the string "500-999".

What is it that you want to return, given an input of 700?


--ron