How to Use INDEX and MATCH with Multiple Criteria in Excel

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024

Комментарии • 4

  • @earthtrack
    @earthtrack 5 лет назад

    thank you for the tutorial, really helpful,
    I have a doubt how did you add anchor to the formula while typing ?

    • @Sintarow1
      @Sintarow1 4 года назад

      Hit F4 and it will anchor your active reference.

  • @erictsang789
    @erictsang789 2 года назад

    What will be the formula in your case if i want to get a approximate match?
    index ((A2:D8,match(1(item)*(size)*(price),1))??
    I want to get the "Less than" result
    What can i do ?

  • @markvalenzuela7010
    @markvalenzuela7010 4 года назад

    does this work for non office 365 users ?