subject: Microsoft Excel Functions MasterClass - the Conditional If Function Explained [print this page] A much better answer is to use a VLOOKUP formula combined with a lookup table, which should be the subject of a separate forthcoming article!
Microsoft Excel Functions MasterClass - the Conditional If Function Explained
