=INDEX(C2:C4, MATCH("Tara", A2:A4, 0)) → Yes ✔️
=LEFT(A2, 2) → "Ri" ✔️
=LEN(B3) → 2 (if marks are two digits) ✔️
=UPPER(A4) → TARA💬 Tap ❤️ for more!
MS MS Excel for Data Analysis @excel_analyst · 73.3K subscribers =INDEX(C2:C4, MATCH("Tara", A2:A4, 0)) → Yes =LEFT(A2, 2) → "Ri" =LEN(B3) → 2 (if marks are two digits) =UPPER(A4) → TARA