How to use Excel Index Match (The Right Way) with Real World Examples in 5 mins!!

แชร์
ฝัง
  • เผยแพร่เมื่อ 11 ม.ค. 2025

ความคิดเห็น • 4

  • @lawrenceNG-k3q
    @lawrenceNG-k3q 15 วันที่ผ่านมา

    Excellent, that solve my problem in my work, thx

    • @sirexcelco
      @sirexcelco  15 วันที่ผ่านมา

      Glad I could help! Let me know if you have any other Excel questions.

  • @lawrenceNG-k3q
    @lawrenceNG-k3q 15 วันที่ผ่านมา +1

    Sir, can you show me how to use Index + Match to sort out a result with 4 criteria ? e.g. 1. Pipe día. , 2. pipe material, 3. the method of laying (e.g. Open Cut), and 4. the depth of excavation, so that I can find the the Rate (I.e. price) for laying a pipe with these 4 criteria ? thank you very much. Further, if the Index + Match function can be used in EXCEL version 2010 ? 🙏

    • @sirexcelco
      @sirexcelco  15 วันที่ผ่านมา

      Yes, the INDEX and MATCH functions are fully compatible with Microsoft Excel 2010. These functions have been available in Excel for many years and are commonly used for advanced lookup operations.
      For the rest you can send an e-mail to sirexcelco@gmail.com.
      Regards :)