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:Score atleast and Grade Table

Jisme Score Atleast ⇒ Grade diye hai

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

Dekho ye kaisa dikhta hai:If Formula

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: