Forum Discussion

El1-_321's avatar
El1-_321
Copper Contributor
Apr 17, 2019

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...
excel
Excel Online
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 17, 2019

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))
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 17, 2019
    A single LOOKUP function can return the same result, like this:
    =LOOKUP(2,
    1/((A6:A12=B1)*
    (B6:B12=B2)),
    C6:C12)
    • El1-_321's avatar
      El1-_321
      Copper Contributor
      Apr 17, 2019

      Thank you Twifoo 

      • Twifoo's avatar
        Twifoo
        Silver Contributor
        Apr 17, 2019
        You’re welcome.