Humhe ek data Diya Gaya vlookup nikal ne ke liye jiss mein name of employees, basic salary, working day ,days present Aisa table hai toh basic salary Vlookup formula dalke kaise nikal skhte hain? Baki column ki amount pehle se hain table mein
Basic salary vlookup se nikalne ke liye Vlookup lagana hoga = Vlookup(a1,sheet1!a1:g30,2,0) Ho sakta hai aapko samjh ne aaye Aap humare course ko join kar sakti ho jaha aap apne personal Doubt clear kar sakti hai aap contact number bhi provide Kiya jayega Agar Join karna chahti Hain to humare app ko download karen App name - abhijeetji technical 4m
Actually humare pas only one minute hota hai topic ko cover karne ke liye isliye thoda speed karna padta hai , but you can join our course every topic explained in depth
@@The_AllRounder18 Download our app from Play Store and join basic to advance Excel with array mastery No one teaching about array mastery , it will help to make you expert in Excel App name -abhijeetji technical 4m
Sir, ye prblm maine bahut face ki hai lekin aapse hi ye problem solve ho pai, thank you so much.
Thoda slow batao.
Itna jaldi kyon hain😂.
Biwi bula rahi hai 😂
Sir please slow bolo
You should have done the vlookup function in col C itself
then, all the existing salary will be replaced with NA which has no updated salary
Itna speed video 2X pe bhi dekhne se nahi dikhta jitna speed aapka video 1X pe hai 😅😅😅
Slow motion me btao
It is very fast
Hahahaha
Humhe ek data Diya Gaya vlookup nikal ne ke liye jiss mein name of employees, basic salary, working day ,days present Aisa table hai toh basic salary Vlookup formula dalke kaise nikal skhte hain? Baki column ki amount pehle se hain table mein
Basic salary vlookup se nikalne ke liye
Vlookup lagana hoga
= Vlookup(a1,sheet1!a1:g30,2,0)
Ho sakta hai aapko samjh ne aaye
Aap humare course ko join kar sakti ho jaha aap apne personal Doubt clear kar sakti hai aap contact number bhi provide Kiya jayega
Agar Join karna chahti Hain to humare app ko download karen
App name - abhijeetji technical 4m
Isme to paste special lagakr mai value krke dusre column me drag kr leta hu..shuru me mai v isi tarah krta tha jaisa aap bata rhe ho
Sir, aap ghar jakar video kyun nhi banaye?????
kuchh samajh m nhi aa raha h.
Bhai Direct vlookup lagake bhi kar sakte the. New colum ki kaha jarurat
Ad the if condition with that column ,
Iferror then the c column
Bhut hard hai vlookup
Khuch bhi hard nahi hota but apne soch ko badlna hai
Thanks
Excel web mein kaise karte hai
But if we will delete 'D' Coloumn so 'C' column value also delete......
After appy formula You have to copy all values and then paste it as values
You can also use if error
Kya iss mai vlookup ke saat iferror laga sakte hai...
Yes
Sir f se kya press kiya tha apne
f4
Sir thoda slow btaiye jo smjh me aa jaye
Ok
❤😊
Sir
ISHME TUNE HACK KYA BATYA ISS SE ATCHHA IFERROR BHI USE KR LETA
😂
Freez f se nahi ho raha hai
@@MithilaNiwasi doing some mistake watch carefully and try again
Rupali to Mera naam hai par salary itni nahi hai 😂
🤣🤣
Sir apka window 19 hai but Mera window 7 hai mere window me nhi ho rha hai
Windows 19 kab aya re
Bahut jaldi bata rahe hai clear nahi ho raha hai
👍
Bhae slow batana
Actually humare pas only one minute hota hai topic ko cover karne ke liye isliye thoda speed karna padta hai , but you can join our course every topic explained in depth
@@GyaniAbhijeetjiExcel ka advance level sikhoge mujhe join krne hai
@@The_AllRounder18
Download our app from Play Store and join basic to advance Excel with array mastery
No one teaching about array mastery , it will help to make you expert in Excel
App name -abhijeetji technical 4m
Bhai thoda dheere
अरे जरा हळू सांगावं
😂
Panvel niklna h kya
Aur speed btawo aap Taki log skip kr de
Ok next time dhime
Why are you explained so fast😒
Bhai halke bolo loa
Smjh ni aya. Zara aram se samjhaiyye
Kuch bi bakshwas mat batao,
Jo real mein use hota hi wahi batao.
Ye to muze pata tha😂😂
Slow bato
Itna fast kuch samaj nehi aya.. aise video ko dislike milna chahiyeh
Freeze kyu karna hai mai toh aaise he karta hu
Excel to bht musjkil ha
@@anumsehar7703 himmat karne walo ki har nahi hoti
@@GyaniAbhijeetji u right but vlookup mei 0 kyu lagaya jata h formula mein end mei
@@anumsehar7703 agar tumhe sari chise depth mein sikhni hai join our course
Download my app and join course
App name - abhijeetji technical 4m
@@GyaniAbhijeetji o ksir I will join soon
Itna fast me kuch samajh nhi aaya
Abehy pagla Zara dire bholna tu paidais itna speed se bolta hein kiya 😡
Yesa kon samjata hai 🤨🤨🤨🤨
Aree itna jaldhi mat batao kuch samaj nhi ataa ...!!!!🤷
F what???
Abe aaram se bata bhai
Bhut complicated h ye to 😢😢😢
Keep practice kuch bhi mushkil nahi hota
फॉर्मला मत छिपाया
Sikhane ka tarike ek dm bekar h
Kuch bhi smjh nhi a raha
Watch carefully and practice aa jayega