Forum Discussion
Index Match multiple results without duplicates
Hi, can anyone help?
I am trying to get a cell to lookup ID2 based on two criterias - Date & ID with the intention of having ID2 returned without the duplicates. A simplified version of the layout is below:
| Date | 1/04/2019 | |
| ID | 1 | |
| ID2 | ||
| Date | ID | ID2 |
| 1/04/2019 | 1 | YEAR1 |
| 1/04/2019 | 1 | YEAR1 |
| 1/04/2019 | 2 | YEAR2 |
| 1/04/2019 | 1 | YEAR1 |
| 1/04/2019 | 2 | YEAR2 |
| 1/04/2019 | 1 | YEAR1 |
| 1/04/2019 | 2 | YEAR2 |
Thank you :)
5 Replies
El1-_321 , it could be like this
=INDEX($C$6:$C$12,MATCH(1,INDEX(($A$6:$A$12=B1)*($B$6:$B$12=B2),0),0))
Thank you SergeiBaklan
- A single LOOKUP function can return the same result, like this:
=LOOKUP(2,
1/((A6:A12=B1)*
(B6:B12=B2)),
C6:C12)
