This user wants a single cell formula. As you all should know, I'm not fond of single cell megaformulas. If you feel inclined, help him hardcode the lookup table inside of my lookup function (or whatever approach you like for this sort of thing).
http://www.excelforum.com/excel-form...l-formula.html