✅ Excel Basics Part 6 – INDEX, MATCH & Text Functions 📌🔤

These functions give you more flexibility than VLOOKUP and help clean and transform data efficiently.

1️⃣ INDEX() – Returns value at a specific row & column
=INDEX(A2:C4, 2, 3)
▶️ Returns value from 2nd row, 3rd column in range A2:C4 → No

2️⃣ MATCH() – Finds position of a value
=MATCH("Tara", A2:A4, 0)
▶️ Returns 3 – Tara is in the 3rd row of A2:A4

3️⃣ INDEX + MATCH – Dynamic alternative to VLOOKUP
=INDEX(C2:C4, MATCH("Riya", A2:A4, 0))
▶️ Returns “Yes” – Riya’s Attendance

4️⃣ LEFT(), RIGHT(), MID() – Extract characters from text
=LEFT(A2, 3) → First 3 letters
=RIGHT(A2, 2) → Last 2 letters
=MID(A2, 2, 3) → From 2nd character, next 3

5️⃣ LEN() – Count number of characters
=LEN(A2)

6️⃣ UPPER(), LOWER(), PROPER() – Change text case
=UPPER(A2) → ALL CAPS
=LOWER(A2) → lowercase
=PROPER(A2) → First Letter Capitalized

📊 Practice Scenario: