you don't need "if/then", simply use the VLOOKUP function. Check outExcel's help on how to apply it. If you still any help, then let meknow.