Hi,

I think VLOOKUP should do the trick but can you upload a sample workbook showing your data layout and desired result.

Dom