I cant give you a formula because you haven't provided enough information. Probably the VLOOKUP function is what you need to learn to do. There is a great deal of information on how to do this function available on the web.