New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: MATCH function

Excel Tips and Tricks

2-way Lookup Using INDEX + MATCH + MATCH Function in Excel with Examples

October 11, 2024October 10, 2026 PKComments Off on 2-way Lookup Using INDEX + MATCH + MATCH Function in Excel with Examples
Are you looking to up your Excel game by learning advanced lookup techniques? Well, you’re in the right place! In today’s tutorial, I’m going to walk you through 2-way lookup
Read More
Excel Tips and Tricks

Use MATCH Function in Excel with Examples

October 7, 2024October 10, 2026 PKComments Off on Use MATCH Function in Excel with Examples
If you’re looking to level up your Excel skills, you’ve probably heard about the MATCH Function in Excel. But do you really know how it works and why it's so
Read More
Excel Tips and Tricks

MATCH Function in Excel with Examples

September 25, 2024October 10, 2026 PKComments Off on MATCH Function in Excel with Examples
If you're diving into Excel for data analysis or automation, the MATCH Function in Excel is a powerful tool to have in your skillset. In this blog post, we'll walk
Read More
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy