Index Match multiple results without duplicates

Copper Contributor

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: 

 

Date1/04/2019 
ID1 
ID2  
   
DateIDID2
1/04/20191YEAR1
1/04/20191YEAR1
1/04/20192YEAR2
1/04/20191YEAR1
1/04/20192YEAR2
1/04/20191YEAR1
1/04/20192YEAR2 

 

Thank you :)

5 Replies

@El1-_321 , it could be like this

image.png

=INDEX($C$6:$C$12,MATCH(1,INDEX(($A$6:$A$12=B1)*($B$6:$B$12=B2),0),0))
A single LOOKUP function can return the same result, like this:
=LOOKUP(2,
1/((A6:A12=B1)*
(B6:B12=B2)),
C6:C12)
You’re welcome.