Vlookup and Data Validation

Last updated at July 20, 2026 by

 

Q3

A person should just select a students name

It should automatically show Marks Obtained,total marks,Marks % and Rank

 

Vlookup and Data Validation - Data Validation

 

Download and try 

DATA VALIDATION ASSIGNMENT.xlsx
 
Remove Ads
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.