# I Bet you wouldn’t know this VLOOKUP Trick | Score Grading

## Learn: Score Grading using Vlookup Trick

Ye Exercise kaam aayegi aapko Score Evaluate karne mai

Score k Hisab se ⇒ Grade milta hai

### Toh dosto, mere saamne ek Table hai:

Jisme Score Atleast ⇒ Grade diye hai

Toh dosto, log Grade nikalte waqt “IF Formual” use karte hai

### Dekho ye kaisa dikhta hai:

Ye bohot he lamba Formula hai, agar aapne ye Problem “IF” ki madat se karna chaha:

Toh aapko itna lamba Formula likhna padega aur agar jyaada Students hue toh usse bhi lamba likhna padega.

Par dosto, ye Excel Superstar ki nishani nahi hai, ye hai Excel Beginner ki nishani.

### Toh chaliye dosto, hum bante hai Excel Superstar Vlookup k sath:

1. Type ⇒ {=VLOOKUP}
2. Lookup Value → Select 89(F6 Cell) ⇒ {=VLOOKUP(F6,}
3. Table Array → Select Whole Score at least & For Grade Table(B5:C13 cell) ⇒ {=VLOOKUP(F6,B5:C13,}
4. Press F4 → Taaki Table niche khiske nahi ⇒ {=Vlookup(F6,\$B\$5:\$C\$13,}
5. Column Index No. → 2nd Column(2) ⇒ {=Vlookup(F6,\$B\$5:\$C\$13,2,}
6. Range Lookup → True/1(Approximate Match) ⇒ {=Vlookup(F6,\$B\$5:\$C\$13,2,1}
Note: True/1 ko use karte waqt 3 Conditions ko Dyan mai rakhna hai:

1. Slab Based Non-Continuous Values
2. At least, Onwards, Not Less Than, >=
3. Ascending Order
7. Press ENTER↵

Waah bhaiya, Answer aagya Score 89⇒Grade A

Aur aap Niche Copy+Paste karoge toh Saare Scores k Grade Mil Jayenge

Toh dosto, abb aap konsa Formula use karoge?

Vlookup Formula right?

#### Toh dosto, aise bohot saare Tricks milege humare Website par:

Excel Course in Hindi [Online Access]
INR 799
Actual Price INR 3̶0̶0̶0̶ / Watch & Learn Excel through videos on TV or Computer, Mobile
90 MP4 videos (Hindi)
87 MP4 videos (English) – Bonus
Total 900+ mins of videos tutorials
Online Access
Free Training Files (For practice)