"Bob Phillips" wrote in message
...
=VLOOKUP(A1,{"Clinton",0.25;"Bush",0.25;"Carter",0 .25;"Taylor",0.37;"Washing
ton",0.37;"Adams",0.37;"Roosevelt",0.45;"Nixon",0. 54;"Pierce",0.99},2,FALSE)


Wow! Thanks so much Bob. It worked! This is so much easier than doing a
binary and nested if formula. :)