You could most likely do everything you need to with the VLOOKUP function. If you post a sample workbook, showing you would be easier.