Vlookup Optimization | Vlookup with other Functions in Hindi
ฝัง
- เผยแพร่เมื่อ 27 ส.ค. 2024
- Learn how to optimize vlookup not in terms of performance or fastness.
We need to apply some fundamental approach before applying vlookup formula as follows.
1. Vlookup with Iferror (Effective way to represent output to user)
2. Vlookup with Naming Range (Reduce our data range selection effort)
3. Vlookup with Data Validation (Best way to show multiple things in single cell)
4. Vlookup as Formula element (After application if we want to manipulate formula as division,multiplication etc)
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#vlookup #vlookupwithother #Innozant #Exceltutorial #vlookupformula
छोटी छोटी मगर मोटी बाते...🙏👍👍👍
It's like realising the importance of a long term share bought of a good company.
Thanks Shrikant..Seems you are on track again wity full energy and dedication.🙏❤️
thank you sir bahut kuch naya shikle ko mil raha ai vloop me ,, abhi tak hume vloop up =VLOOKUP (value, table, col_index, [range_lookup]) yaha tak pata tha aap se aur baatein pata chali aaj thank you sir so much
Thanks Pawan Ji
Mere jitne bhi doubts hai excel co lekar vo sab clear hote jaarahe hai....thank you so much sir
🙏♥️M happy for you.Apko is video se life me value add ho rha hai,skills apoa improve ho rha hai ,Ye mere liye sabse badhke hai dear,Humesha Joshuah krenge seekhate rhne ki.Love you all🙏♥️🤣😘
Thanks for your response sir,I wanna chat with you personally sir,I need your help to improve my skills
Ok..you may connect with me on Telegram I'd -@innozantofficial
@innozant isse accha vlookup video ban nahi sakta.
Thanks Arpan
Allah apko kamyabi ki bulandi tak leker jaye Ameen, mene youtube man itna expert sir nahi dekha,
very well trick bohot zaberdast super se bhi uper hoti hai apki video.
Thanks Saqlaij apke itne pyare comments ke liye dear
Sir i want to say from bottom of my heart you are excel ❤
Thanks dear
.keep learning
lookup as formula ailment बहुत शानदार 🙏🙏👍👍
Thanks Manish ji ❤️❤️
सर आप हर टॉपिक बहुत अच्छा समजा ते हो
Thanks dear Balkrishna❤️
All concepts v clear
Thanks dear
What a solution Dilip sir for formula element your great
Thanks Swapnil
Learned something new in Vlookup 🙏
Thanks dear, Happy Learning
Waah. Thanks Sirji.
You are god of Excel...
Thanks Rajesh Ji
bahot umda ha cioncept sir aaap ka lawajawab hai
Thanks Sawai
Again good content delivered 🙌😊🙏
great sir.... your explainetion is awesome👍
Thanks dear
Omg ..the last one
Thank u sir
Thanks Saira❤️❤️👍
Love u sir from.pak.❤
Thank you so sooooooooooooo mcuah
Very very good sir
Thank you
very good technique sir & useful
Thanks
thanks a lot sir
Awesome sir ji👌
Great
La jawaab..👌👌👌
Thanks Vandana🙏❤️
THANKS SIR
Sir
V look lagane ke baad naming range de diya, but jo column ki value lani hai Wo 25-26-27 ki lani hai wo kaise laynge
thanks a lot
very great sir
Gd
Great work boss. Keep it up.
Thanks dear❤️🙏
sir one question if we give data range name then how we will add new data
Sir dusure sheet me tabale ka nam denese vlookup kam nehni Karen hei
Isme 2 nokia h product and prise change h dono me ye kse krenge
If both product are same we apply duplicate vlookup.
Upcoming video me sikhenge duplicate vlookup concept.thanks for subscribe and watching our videos
Good
Sar Agar Hamara Lookup value ek hi naam ka बार-बार Diya Hua ho aur Mujhe sabka data chahie to kya karun
Tab aapko apne table array ke first column mein countif formula ka use karna padega duplicate ko unique banane ke liye
Thanks sir ...
Sir,
Power query mai
Add conditional conditional column ka option show nahi ho raha hai,iska
Mcode Syntex batane ki kripa kare
Good work
sir data validation kesa found krna hain
I want to talk some excel problem , need your help.please reply
you are best
Good noon sir,
Sir Vlookup with Named Range me table ka name tabhi denge jab hume last column ki value chahiye ho ya fir kisi bhi column ki value?
Kisi bhi column ki value lana ho tab bhi naming range deke rakhenge wo aur acha hai
When we are applying iferror(vlookup) and it's gives text and number value a result,than I want to add that result by sum function,it gives us error,can we add both cell result of iferror(true(number)) with iferror (else(text))
It gives error
Double coma m likho msg ko
=Iferror(vlookup),"msg")
Sir data validation mere system pe open ni ho ra no cells were found aa jata hai
Kaunsa version excel ka hai system me aapke ?
Sir agar vlookup lagaye aur lookup value mein kisi ka naam hai jaise Manoj aur table Arey mein Manoj 5 hai to v lookup Kaise bta payega konse wala Manoj hum search kar rhe hai
Duplicate vlookuo video dekhiye channel par available hai
Good trick sir
Thanks Sarvesh Pal Ji🙏❤️
Hello Sir, In Vlookup with Data validation part if we apply filter to the range then some values are Repeating in the range such as Nokia. and If we are applying Vlookup to it It is taking 28.95 and even if are selecting second nokia in data validation filter also it is taking 28.95 as Vlookup First Prioritizes the Ascending order first number. What is the solution for duplicate dynamic ranges which have different prices? Kindly please explain.
🙏🙏❤️ sir g
Guruji, How to manage repeating names in a lookup search?
Using duplicate vlookup approach..Kindly watch more videos of lookup series and interview Series.You will get the answers
@@Innozant sure
Sir, Can we make cell row height dynamic to fit the contents automatically during
lookup function . Is it possible? Please revert if you know.
Didnt get your query..Yes we are able to make row height dynamic..
To fit the content automatically?? Based on what?
Sir,
If we link cell of one sheet by another sheet by equal to sign,
Any short trick to see or go from source celll to resulting cell directly,
Reverse from linked cell to see quikly where or in which formula it used
I think last moto* unit wale example ka answer kuch or hona chaie.
Qki vlookup lga k to array me first moto ka price nikla na k 1 unit moto ka. Or Usko apne 3 s multiply kr dia.
31.95*3=95.85
Sir my data name kese create kiya wo dikhayi ni diya screen m
Naming range ..Formula tab me jaake kiya hoga dear
Google Drive mein Koi bhi practice sheet sahi se maintain nahi ki hain aapne, sab idhar udhar hain, badi mushkil se dhundhna padta hain
Everything is there inside playlist folder ,Yes individual link was broken that's why folder link given.
Sir vlookup*unit jab kar ra hu value error aara h
Vlookup with formula element me koi issue nhi hain.check kriye kahin vlookup ho to galat nhi laga rakha hai jiske wajahse value error
Sir please teach me online 🙏 Aap kahan se hai
Kindly connect with team innozant or visit innozant website for more details
Sir price se dollar ka sign remove kr doo samjh ne problem hota hai
Ok .Aane wale Videos me dhyan rakhenge dear ❤️
Sir just i want to asked that thre is an one sheet & we have to go for another sheet that time what can we do in tab;e array
Yes we can
Sir, es data m "Moto" two times h and vlookup first wala ko hi pic kiya tha. To kya vlookup unique data pe work krta h?
Yes bilkul krta hai ..duplicate Vlookup ka concept aage karaya hai wo video dekhen
aapke videos me sir double like ka bhi option hona chahiye tha , aapki video ko sirf ek like dene me bilkul achha nahi lagta hai,,,,
Hahahaha..Thanks Dear Happy Learning ❤️
Hi sir, table mein toh moto ke values to different hai, par dikha toh highest value hai. Duplicate values ke liye kya karna hoga? Aur toh multiplication kiya hai woh bhi galat hai, because values different hai. Please explain!
Galat hai means.video ka time mentuon kijiye dear kahan par apko galat lag ra hai ya nhi aa ra smajh?
And we don't need to freeze Array if we have saved the array with any name, Right?
👍❤️
❤️❤️❤️❤️
Bhai jan, aik baat batain, can the table array in vlookup, be automatically changed as the lookup value changes,
Yes it can be done
Sir isme last example apne * karke $31.95*3 = 95.85 answer nikala humare is #value error bata raha
Aisa kyu ..Dubara attempt kijiye ya file download krke kar lijiye practice
@@Innozant Lagta h Sir ne patent kara liya h Example ko😄😁, Just for Fun..😁😁
@@sachinkumarsingh2518 haha Thanks Sachin...
@@Innozant Most Welcome Sir 😄😄
Sir I have some questions about this table have name are duplicate but vlookup find only first value and given example moto price of unit 35 = 31.95 how we know single value for 1 unit with formula elements please explain
Didn't get you Gagan,If you want to go for duplicate vlookup in that case we need to use countif to find out occurance with help of helper column.Kindly explain your query again.
@@Innozant sir there row value is 35 unit is 31.95 but we need value only 3 unit then which formula we used
@@Gagansingh-ct4jt bhai if English isn't your strong mode of communication, kyun na Hindi mein puchhleta?
If whith vlookup me 2007 nhi ata
Kyu?
how to find price for 5 unit of samsung ?
Hi Deeksha, Welcome you to Experince the taste of Success.
Kindly elaborate your query.
Ok Got it..Use vlookup with formula element. e.g. if you want to find price of Samsung and unit qty is 5.
Vlookup (Lookup Value,TableArray,column index,0)*qty cell reference.
Stile doubt or query you may message or call us.Will help you out
@@Innozant thanks!
Sir My name is Sameer and i Mailing a MIS question, kindly reply whenever you are free
unit price is not same
Jo akhir me सिखाया wo galat hai , sir me math teacher hu ye galat hai according to basic rule of math
1 Moto ka price = 4.95 to 3 moto का price hoga = 4.95*3=14.85
Nisha Ji sidhe galat ka certificate dene se pehle ek baar phirse video dekhen😃
moto jahan first occurrence hai uska kya price hai ?? 31.95 aur unit multiply Kiya hai 3 se that means 3 unit chaiye to Kitna hue 95.85..umeed karta hu video me yahi output hoga..❤❤🙏🙏4.95 price kahan se pick kar re hain aap..Maine vlookup as formula element batane ki koshish ki hai na ki basic rule of math seekhame ki
@@Innozant sir, wo table me sabse niche moto ka price 4.95 लिखा है isliye कहाँ मैंने
Nisha Vlookup jab lagayenge to default kaunsa value lega..1st na ? phir 😀Duplicate vlookup nhi chalaya hai na?
@@Innozant Hello Sir, Yaha pe logo ko mostly price me confusion hai means jo first table me price liya hai uska heading sirf price likha hua hai instead usko per unit price mention krna tha jis sab log wo total units ki price samaj rahe hai..jaise 35 unit total price= 31.95 Rs.
Mera bhi ek question hai. Jiase ek product ke 2 or 3 different prices hai jaise table me mentioned hai for eg: Moto ka, to hum issko differentiate kaise krenge? Isske liye humko Part number bhi consider krna padega na? To ye kaise krenge issi formula me?
🌟🌟🌟🌟🌟
thanks a lot
🌟🌟🌟🌟🌟
Hi Manpreet, Welcome you to experience the Taste of Success.
Learn --Enhance Skills -Placed or Change your current Profile.Happy Learning dear.
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot
thanks a lot