Formula Help!!!

[mlukich]

I'm trying to get this formula but I can't seem to get it down...

Basically, I have a table with 5 values for A, B, C, D, and E.

I have a second table that also has A, B, C, D, and E. I want to assign a number value next to each letter. Basically, I want to lookup the first table and assign a 5 to the highest value in the first table, 4 to the next highest value, 3 to the 3rd highest value, etc.

How would I do this?

[shg]

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

[shg]

Thread closed.