EXCEL INTERVIEW CRACK KARNA HAI? Seekhiye Skipped Rows mein VLOOKUP Lagane ki pro Trick!

HOW TO USE VLOOKUP IN MS EXCEL ON SKIPPED ROWS ?

Hum sabne basic VLOOKUP toh seekh liya hai, lekin asli test tab hota hai jab interview mein interviewer aapke samne ek aisi sheet rakh de jisme  beech beech mein khali rows ho. Zayada tar log yahan galti karte hai - wo ek ek karke formula lagate hain ya drag karne ki koshish karte hai jisse data messy ho jata hai . Par ab tension lene ki jrurat nahi hai Aaj ke blog mein hum Excel learning By Ritesh ki ek kamal ki trick discuss  karenge jo aapko Ms excel me kaafi kaam me aayegi . 

STEP BY STEP : 

Step 1 : BLANK CELLS KO SECONDS MEIN KAISE BHARIEN?

1. Sbse phle MS Excel open karein jha formatting karni hai. 

2.Ab  us column ko select kijiye jo ki blank hai . 

 

3.Keyboard se Ctrl +G press karein . 
 "Go To Special " 

4.Ex box khulega,niche"Special" par click karein. 

5.List mein se 'Blanks' select kakre "OK" Button press  karein. 

Ab aap dekhenge ki sirf wahi cells highlight hue hai jo khali the, Baki data safe hai . 

STEP 2:- Formula Type karein.

yahan ek important bat ka dhyan rkhe  ki jab blank row select ho jaye to Mouse se kisi bhi cell pe click na kare nahi hi type kare Agar aapne khin click kiya to selection hat jayega aur forumale apply nahi hoga to sidha formula type karenge.

=VLOOKUP(LOOKUP_VALUE, TABLE_TABLE _RANGE,column _no,0)

2. Ctrl +Enter

Normal Enter press na karein use sirf phli cell bahri jayegi . Lekin hume sari blank rows ek sath bahrni hai 
to iske liye bs Ctrl button ko press krke rkhe or enter button bhi sth mein press krein. 

ab aap dekhenge ki sari ki sari skipped rows mein VLOOKUP lag chuka hai . 

CONCLUSION 

Excel interview mein speed aur accuracy hi sab kuch hai. CTRL+G aur CTRL+Enter ka yeh combo aapka kam minto me kar deta hai.To Excel mein easi interseted tips and tricks janne ke  hume follow karein.  

RELATED VIDEO :-