🚀 LEVEL 8: ADVANCED EXCEL

🔷 PART 1: Advanced Formulas – INDEX + MATCH (Very Important ⭐)

📌 Why not only VLOOKUP?

INDEX + MATCH is more powerful and flexible:

• Can look left or right
• Doesn’t break if columns move
• Faster for large data

1️⃣ Understanding INDEX

📌 Theory

INDEX returns a value from a table based on row & column number.

📐 Syntax

=INDEX(range, row_number, [column_number])

Example:

=INDEX(B2:B3,2)

✅ Result → 40000

2️⃣ Understanding MATCH