I used this code in cell R2 Sheet1
=MATCH(1, (E2=Sheet2!$E$5:$E$12) * (F2=Sheet2!$H$5:$H$12) * (H2=Sheet2!$F$5:$F$12), 0)
Enter the formula by pressing Ctrl+Shift+Enter. Copy down.
Then I entered the formula in cell S2 Sheet 1
=INDEX($A$5:$A$12, R2)
Copy Down.
This only gives me 1 instance of the matching value. I would like to get all the matching values and not only the first match. How would that be possible ?
Bookmarks