Randy Harmelink wrote:
I can't use VLOOKUP because I'm using the percentile function to determine the grade. <<

Why would that invalidate VLOOKUP? It would just mean the lookup
column of the table is based on calculations instead of being constants.

Randy,
If I understand correctly, VLOOKUP would work. However I
would need 10 seperate lookup tables. One for each of my measure
columns.

That's not necessarily a bad thing. I had just envisioned
trying to use a single lookup table. and I couldn't see how that would
work.

Thanks for you help.

Karl