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 layou...
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)
=LOOKUP(2,
1/((A6:A12=B1)*
(B6:B12=B2)),
C6:C12)