Finding Matches With Multiple Return Values

Hi All,

I'm working on a spreadsheet trying to match up values. I've attached a sample spreadsheet on here.

Basically what I need to do: Take the value from column A and find the matching values from column B. In this scenario, there will always be 2 equal values in column B for the 1 value in column A. I then need those rows to be matched up (For example, the value in A2 has two matches in cells B6 and B7, so I need to align B6-E7 with A2.) Let me know if this is possible.

Thank you!

Hello ajulian, what I am assuming that you are doing a match of A2, now that match you want to index but you are getting the result of E6 but as a result you want to have E7. If I am correct then go with =INDEX($E$2:$E$7,MATCH($A2,$B$2:$B$7,0)+1) you will have a match of E7 which i think you are looking for.
Change the references if your actual data is different.

Regards

If this answer helps you click" * " add rep icon in the bottom left post of my corner and mark the thread as solved