Forum Discussion

bozhkov's avatar
bozhkov
Copper Contributor
Oct 07, 2023
Solved

Array cell reference based on three values

Hi! Please help me find the values based on my example

 

excel
office 365

4 Replies

    • bozhkov's avatar
      bozhkov
      Copper Contributor
      Oct 07, 2023

      HansVogelaar 

      Thank you very much for your help, you answered my question completely. But as it turned out, this was not enough to solve my task.
      Is there a way to fill the formula dynamically since the range of unique values being looked up may change?

      --

      P.S.

      СУММПРОИЗВ = SUMPRODUCT

      ЕСЛИ = IF

Resources