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?