Vlookup Optimization | Vlookup with other Functions in Hindi

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

[@shrikantbadge3978]

छोटी छोटी मगर मोटी बाते...🙏👍👍👍 It's like realising the importance of a long term share bought of a good company.

[@Innozant]

Thanks Shrikant..Seems you are on track again wity full energy and dedication.🙏❤️

[@pawanwakale8801]

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

[@Innozant]

Thanks Pawan Ji

[@rounaqara5737]

Mere jitne bhi doubts hai excel co lekar vo sab clear hote jaarahe hai....thank you so much sir

[@Innozant]

🙏♥️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🙏♥️🤣😘

[@rounaqara5737]

Thanks for your response sir,I wanna chat with you personally sir,I need your help to improve my skills

[@Innozant]

Ok..you may connect with me on Telegram I'd -@innozantofficial

[@muhammadsaqlain5162]

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.

[@Innozant]

Thanks Saqlaij apke itne pyare comments ke liye dear

[@balkrishnavengurlekar8520]

सर आप हर टॉपिक बहुत अच्छा समजा ते हो

[@Innozant]

Thanks dear Balkrishna❤️

[@ManishVerma-gg8xl]

lookup as formula ailment बहुत शानदार 🙏🙏👍👍

[@Innozant]

Thanks Manish ji ❤️❤️

[@ABSTIC1]

@innozant isse accha vlookup video ban nahi sakta.

[@Innozant]

Thanks Arpan

[@rajeshsenan7716]

You are god of Excel...

[@Innozant]

Thanks Rajesh Ji

[@swapnilpawar708]

What a solution Dilip sir for formula element your great

[@Innozant]

Thanks Swapnil

[@proudkumauni6988]

Sir i want to say from bottom of my heart you are excel ❤

[@Innozant]

Thanks dear .keep learning

[@sawaimalhi8439]

bahot umda ha cioncept sir aaap ka lawajawab hai

[@Innozant]

Thanks Sawai

[@msexcelgooglesheet374]

Learned something new in Vlookup 🙏

[@Innozant]

Thanks dear, Happy Learning

[@user-hq5gr9hk1j]

All concepts v clear

[@Innozant]

Thanks dear

[@brijeshshah574]

Again good content delivered 🙌😊🙏

[@mrperfect6472]

great sir.... your explainetion is awesome👍

[@Innozant]

Thanks dear

[@shrikantbadge3978]

Waah. Thanks Sirji.

[@sairaaslam3292]

Omg ..the last one Thank u sir

[@Innozant]

Thanks Saira❤️❤️👍

[@excel-nh4cq]

sir one question if we give data range name then how we will add new data

[@huzaifahshah3841]

Love u sir from.pak.❤

[@motivationalarunsingh]

Very very good sir Thank you

[@shyamallrounder]

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

[@iamvpunj]

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?

[@Innozant]

Kisi bhi column ki value lana ho tab bhi naming range deke rakhenge wo aur acha hai

[@vimleshsingh5708]

Sir, Power query mai Add conditional conditional column ka option show nahi ho raha hai,iska Mcode Syntex batane ki kripa kare

[@srilathagollapudi9868]

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.

[@vikranthpatro1872]

Sir, Can we make cell row height dynamic to fit the contents automatically during lookup function . Is it possible? Please revert if you know.

[@Innozant]

Didnt get your query..Yes we are able to make row height dynamic.. To fit the content automatically?? Based on what?

[@pranaypanchal5220]

very good technique sir & useful

[@Innozant]

Thanks

[@vimleshsingh5708]

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

[@ManjeetSingh-th4fu]

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?

[@Innozant]

Yes bilkul krta hai ..duplicate Vlookup ka concept aage karaya hai wo video dekhen

[@775shahrukh]

Thank you so sooooooooooooo mcuah

[@dhakafady774]

thanks a lot sir

[@meh3ndishow474]

La jawaab..👌👌👌

[@Innozant]

Thanks Vandana🙏❤️

[@kinghundred]

very great sir

[@VimalKumar-ih6ik]

Great

[@mohammadsiraj3132]

Awesome sir ji👌

[@aamirmasood4655]

Bhai jan, aik baat batain, can the table array in vlookup, be automatically changed as the lookup value changes,

[@Altaf_Alam]

Yes it can be done

[@TheSphooljaan]

I want to talk some excel problem , need your help.please reply

[@arvindtech408]

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

[@Innozant]

Duplicate vlookuo video dekhiye channel par available hai

[@dhakafady774]

thanks a lot

[@bilalsultantyaagi2349]

THANKS SIR

[@rahuljuyal4120]

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.

[@siddhbirsingh791]

31.95*3=95.85

[@-_AshrafulIslam]

Great work boss. Keep it up.

[@Innozant]

Thanks dear❤️🙏

[@govindgoel2442]

sir data validation kesa found krna hain

[@miralpatel3340]

Good work

[@ankitprashar4022]

And we don't need to freeze Array if we have saved the array with any name, Right?

[@Innozant]

👍❤️

[@karankapoor200]

you are best

[@gauravbhatia7987]

Good

[@JaniChetankumar]

Guruji, How to manage repeating names in a lookup search?

[@Innozant]

Using duplicate vlookup approach..Kindly watch more videos of lookup series and interview Series.You will get the answers

[@JaniChetankumar]

@@Innozant sure

[@gauravverified]

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!

[@Innozant]

Galat hai means.video ka time mentuon kijiye dear kahan par apko galat lag ra hai ya nhi aa ra smajh?

[@ranjannayak5718]

Sir dusure sheet me tabale ka nam denese vlookup kam nehni Karen hei

[@sarveshpal774]

Good trick sir

[@Innozant]

Thanks Sarvesh Pal Ji🙏❤️

[@vimleshsingh5708]

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

[@vipingujjar6020]

Double coma m likho msg ko =Iferror(vlookup),"msg")

[@pranaypanchal5220]

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

[@Innozant]

Yes we can

[@virendersroha1754]

Isme 2 nokia h product and prise change h dono me ye kse krenge

[@Innozant]

If both product are same we apply duplicate vlookup.

[@Innozant]

Upcoming video me sikhenge duplicate vlookup concept.thanks for subscribe and watching our videos

[@Gagansingh-ct4jt]

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

[@Innozant]

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.

[@Gagansingh-ct4jt]

@@Innozant sir there row value is 35 unit is 31.95 but we need value only 3 unit then which formula we used

[@sanevoice3723]

@@Gagansingh-ct4jt bhai if English isn't your strong mode of communication, kyun na Hindi mein puchhleta?

[@motivationalshayarisneha1210]

Sir data validation mere system pe open ni ho ra no cells were found aa jata hai

[@Innozant]

Kaunsa version excel ka hai system me aapke ?

[@AnujKumar-fc8xs]

Sar Agar Hamara Lookup value ek hi naam ka बार-बार Diya Hua ho aur Mujhe sabka data chahie to kya karun

[@Altaf_Alam]

Tab aapko apne table array ke first column mein countif formula ka use karna padega duplicate ko unique banane ke liye

[@Cartoonsbabu]

Sir please teach me online 🙏 Aap kahan se hai

[@Innozant]

Kindly connect with team innozant or visit innozant website for more details

[@virendersroha1754]

Gd

[@pawanwakale8801]

Sir isme last example apne * karke $31.95*3 = 95.85 answer nikala humare is #value error bata raha

[@Innozant]

Aisa kyu ..Dubara attempt kijiye ya file download krke kar lijiye practice

[@sachinkumarsingh2518]

@@Innozant Lagta h Sir ne patent kara liya h Example ko😄😁, Just for Fun..😁😁

[@Innozant]

@@sachinkumarsingh2518 haha Thanks Sachin...

[@sachinkumarsingh2518]

@@Innozant Most Welcome Sir 😄😄

[@jaymasaraswati1439]

🙏🙏❤️ sir g

[@deekshaagrawal6105]

how to find price for 5 unit of samsung ?

[@Innozant]

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

[@deekshaagrawal6105]

@@Innozant thanks!

[@saptutorialbyrohit4013]

Google Drive mein Koi bhi practice sheet sahi se maintain nahi ki hain aapne, sab idhar udhar hain, badi mushkil se dhundhna padta hain

[@Innozant]

Everything is there inside playlist folder ,Yes individual link was broken that's why folder link given.

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@AmitGupta-bl2iu]

Sir price se dollar ka sign remove kr doo samjh ne problem hota hai

[@Innozant]

Ok .Aane wale Videos me dhyan rakhenge dear ❤️

[@واجدسليجخان]

Sir my data name kese create kiya wo dikhayi ni diya screen m

[@Innozant]

Naming range ..Formula tab me jaake kiya hoga dear

[@wrongturnlima007]

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,,,,

[@Innozant]

Hahahaha..Thanks Dear Happy Learning ❤️

[@letztalkufc]

Sir vlookup*unit jab kar ra hu value error aara h

[@Innozant]

Vlookup with formula element me koi issue nhi hain.check kriye kahin vlookup ho to galat nhi laga rakha hai jiske wajahse value error

[@ashikalimomin5688]

If whith vlookup me 2007 nhi ata

[@Innozant]

Kyu?

[@sameer2532]

Sir My name is Sameer and i Mailing a MIS question, kindly reply whenever you are free

[@ManishVerma-gg8xl]

🌟🌟🌟🌟🌟

[@nishachauhan9103]

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

[@Innozant]

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

[@nishachauhan9103]

@@Innozant sir, wo table me sabse niche moto ka price 4.95 लिखा है isliye कहाँ मैंने

[@Innozant]

Nisha Vlookup jab lagayenge to default kaunsa value lega..1st na ? phir 😀Duplicate vlookup nhi chalaya hai na?

[@NishantKumar-fv4mn]

@@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.

[@NishantKumar-fv4mn]

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?

[@GouravKumar-e4f]

unit price is not same

[@Unfiltered_ind]

Thanks sir ...

[@dhakafady774]

thanks a lot

[@ManpreetKaur-uz8jv]

🌟🌟🌟🌟🌟

[@Innozant]

Hi Manpreet, Welcome you to experience the Taste of Success. Learn --Enhance Skills -Placed or Change your current Profile.Happy Learning dear.

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot

[@dhakafady774]

thanks a lot