You would normally use a VLOOKUP formula to do this (or possibly an INDEX/MATCH combination, depending on how your data is laid out). It is difficult to advise you more fully without any details of how your data is laid out - perhaps you should attach a sample Excel workbook.

Pete