tupham is absolutely right. The Vlookup feature is very effective for this. You only need the reference cell, a table, and the column number. its about 1 step above the IF formula for difficulty but it is one of the best.