Hi NBVC,

I'm sorry to bug you again but I have been trying to solve one more issue with this project. I have descriptive columns to the right of column A for each Raw key (column A). Basically, I need to identify all the keys that match in column H and then populate columns I:M with the values of the key that has the most descriptive values in columns B:F.

See what I manually copied and pasted in columns I:M; the formula i need should give me these values in these cells.

Thanks again!!!!!!!