Hello,

I have an index and match formula. The problem is that its picks up a cell twice instead of the different value. I have attached the workbook for you to have a review and come up with a solution.

I don't know if an array formula is the answer.Formula sheet.xlsx