Apr 17 2019 03:40 PM
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 :)
Apr 17 2019 04:04 PM
@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))
Apr 17 2019 06:18 PM