Excel CHOOSE FUNCTION | How to use VLOOKUP with Choose Function without Helper Column | Hindi
HTML-код
- Опубликовано: 22 окт 2020
- Learn how to use Vlookup and choose function together with and without using helper column.
1. Vlookup and Choose Formula to extract Result of student with helper
2. Vlookup and Choose Formula to extract Result of student without helper 3. Vlookup to extract Subject Marks of Student with two lookup value
Download the Practice Workbook Direct Link
drive.google.com/file/d/14WRS...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#chooseformula #excelchoosefunction#Innozant #excelformulasandfunction
Excellent. very informative, useful. Thanks on behalf of all Excel users/learners/addicts for doing a great job indeed.
Than Gopala Sir for such a wonderful feedback.🙏♥️🙂
Bahot badiya
This is the most valuable vedio for me. Thank you
Thank you
&
Thank you
Thanks Alokesh..Happy Learning dear👍🙏❤️
Salute sir 🙏.I learnt a lot from your videos.
great one
Apko Dil se "SALAM"।
Thankyou Sir...great!🙏
excellent👍
thank you very much sir. aap ki video dekh k mera kaam ban gya. thank you again.
Thanks Vicky Ji
You are really great
very excellent sir
पर्नाम सर जी। सर मजा आ गया यै concept shikhkar आपने बहुत ही खूबसूरत तरिकै सै describe करा। You are Great. You are my favourite teacher.
Thanks Sandeep.Have a great day🙏♥️
Superb sir
Thank you for sharing your knowledge guru g
Thanks Puran.Keeo supporting 🙏♥️
Thanks you sir, choose is really interesting and useful formula.
Thanks Hemant Ji..GN.🙏♥️
Thanks a lot, SIR
You worked hard for us. Hats off
❤️❤️👍
Thanks sir.
आपके वीडियो का हमेशा इंतजार रहता है, क्योंकि आप हमेशा कुछ न कुछ नया और रोचक लेकर आते हो।
Choose fucntion का इतना बढ़िया use आपके वीडियो में ही देखने को मिला।
बहुत बहुत धन्यवाद।
Thanks Tejpal Ji🙏♥️🙂
Thanks Sir
Thank You
thanks a lot sir
Very nice.
Thank you for such an excellent video, it helps a lot:)
Thanks
Excellent
your knowledge is Excellent Sir
Thanks Dear❤️🙏👍
Excellent 😊🙌🔥👌
Very nice video vlookup & chose function formula thank you and Happy vijayadashmi
Thanks Pramod Ji..Same to you dear🙏♥️🙂
Superb work Sir, Your all videos are too clear and informative to learn.
Thanks dear .Keep learning ❤️
You learn all in a good method and choose a good subject.
Thanks Anil Ji❤️
Great knowledge 👍
Thanks Ajay ji
thank you so much sir it will help.:-)
Thanks Naveen ji❤🙏
Excellent sir
❤️❤️❤️ thanks
Good one!
Thanks Asim Sahab..Happy learning
Very very useful concept
Thanks Bhoopendra ji.gn.🙏♥️
very useful sir 👍🏻👍🏻👍🏻👍🏻👍🏻
Thanks Vijay ji
Thank u sir
Thanks dear
Sir teaching excellent
Thanks ❤️
Dear Sir,
I have a query. In this formula "=SUM(HLOOKUP(L1,$L$2:$M$5,{1,2,3,4},0))", there are only four values that I have added by using array method. But what if there are 40 or 400 values? how to add them usign Hlookup?
Sir yee sumifs se bhe nikl jayega
Thnq sir
👍🙏❤️
Nice very useful sir ji
Thanks Sarthak Sahab🙏♥️
❤️❤️❤️❤️
Sir vlookup+choose horizontal table pe bhi chalta hai kya
Loves from Pakistan ❤❤❤
Very good Sir ji
🙏♥️
Sir vlookup wirh offset formula using apply sir is topic par video banao
Bahut pratice karni padegi iski..
Yes...Do practice on regular basis
Choose concept clear with your explanation thanku very much sir but I have ask one questions. At what type of questions we use seperator good night sir.
Thanks.There is no need to use seprator as it's not mandatory ,We are using this just for our convenience.Good Night
Sir agar isme multiple table ho or range fix nhi ho to....plss sir help me ......
6:26
sir apne yha jo samsung, nokia ,apple ko numbering di h ye helper column me nhi mana jata kya.
ek trike se ye bhi to helper column hi h.
agr interviewer is new table ko create krne me bhi interested na hoto kya krenge?
sir i know ki formula ke andr manually bhi table ki values likh ke kr skte h but agr sirf 3 hi items na hoke 1000 items hue to manually problem ho skti h .
sir answer mil gya indirect series me 🙏😊
Haan Sahi soch rhe aap but without helper column wale solution me koi issue nhi aayega..nubering to choose ko index number paas krne ki wajahs was Diya hai na
@@Innozant yes sir, mujhe idirect vali videos me answer mil gya iska.
apne sach me koi question chora hi nhi h shyad.hr method se question kra rkhe h.
mene indirect wali video dekhi apki to usme kra rkha h apne isi problem ka solution
thankyou sir🙏😊
Haan Ishu...AAP harek playlist step by step dekhnge to aapko har concept in depth milega waise hi Jaise main Yahan Innozant me Live class me padhata hu same even usse jyaad content RUclips platform par upload Kar rha hu❤️🙏
@@Innozant
sir yhi to apke channel ki khas bat h jo mujhe achi lgi.sb kuch provide kr dete ho ap.aur khi jane ki jrort hi nhi 🙏😊
Hi sir muje revars lookup ke sath multipal value me chahiye to kese kar sakate hai meri excel aapke sath share karani ho to kese karu please help
@innozantofficial telegram id
Make video on IF+CHOOSE function
👍
Sir I know ye sb bohot important h interview or knowledge gain krne k respect m.. But itna depth m jana pdta h kya ek mis employee ko....ye sb use hota h kya normal excel use m as an employee?
Jitna depth me aayega wo achi baat hai na dear
Hi sir please i want to learn dynamics function
So pls share dynamic formulas question
Question:
In a sheet there are two different tables with the headers as ID, Name, Product, Location.
Both the tables have different data.
Now there is a search output table that contains data only for ID which has a mix of both table 1 & 2 data. Excluding Name Header.
Which Function/ Formula or combination Functions should we use below the Product Header to get the output for both?
Kindly share the solution.
@innozantofficial telegram id..yahan bhejen sheet..will see
@@Innozant solved!!!!
Iferror(vlookup(match(vlookup). With these functions got the result.
Sir helper column ke saath reference error aa raha hai 2:20 pe aur without helper column pe exact values aa raha hai
Reverse vlookup bata dijiye sir
i have one question if i don't want create " Samsung 1, Nokia 2 and Apple 3 " Table Then How do solve please reply
Dear solution is already there in example before I explain this example 🙏
Hello sir
I want to request you to please make a video of using vlook up with choose from another sheet.. I faced this problem.
Ok..Give me time.
will make video for the same.
isme INDEX+ MATCH nhi chal skta kya sir ." mohit" and "unit test" vale question mein
HAn usse bhi ho skta h
Sir without helper column, we can also find the result with the help of this formula
=INDEX($C$2:$C$19, MATCH ($E3&F$2, $A$2:$A$19$&$B$2:$A$19, 0)
{1;2}does not work with excel 2019 what is the alernative to define array input
Why..? Therr is no issue in array formula ik excel 2019..whats prov you are facing now
@@Innozant yes it is correct but in my version after function evaluation {1,2 } the second parameters did not work . I also relaized that your versions uses , to separate the parameters in the function while in my own is ; .
excel vlookup 0 and 1 exject match . what iS meaning ????
How to use vlookup when lookup value is formula
I want to learn vlookup with indirect or match
Mere pass ek table hai jisme three column hai ek name, cast, and amount. Mujhe ek proper cast mese higher amount wala person ka naame nikalna hai. Kaise nikalu?
Table is:
Name. Cast. Amount.
Rajeev. Sc. 100
Naval. Sc. 115
Suresh. ST. 200
Mujhe sc cast ka higher amount wale ka name nikalna hai kaise nikalu
Sir agar isme aapne e table liye hai...
Samsung
Nokia
Apple....
Agar inke range badha di jay to .....
Iske upar ek video leke aaiye pls vo bhi dynamic vlookup ke sath pls sir i hummble request you ...and now i am waiting for your video.. ❤️
Reply jaror kijiyega please
Range badha diya jaye to dynamic range ke liye vlookup ke saath offset haina humare paas..in sequence video dekhte jaiye aur seekhiyemmaa jayeg topic Jo aap chah rhe hain
@@Innozant tqqq so much
Sir, some issue in googlesheet with this formula. Kindly help.
Hi Shikha..kindly share your query..@innozantofficial telegram id
Thaaaaaaaaaaaaaaaaaaaaaaaaaaaanks
I
Thaniks Rasel Sheikh Sahab.have a njce day
@@Innozant welcome. Actually i have found more than hundred channel for " vlookup without helper column"
And would you please share " unique value dropdown list"?
Thanks and B/R.......keep it up
Sir ye freeze kaise or kaha karte hai.. Iskho thoda bataiye...
Basic excel playlist me Formula reference ke videos dekhen.
Aapke saare doubt freeze krne se related clear honge
Sir kisi person Ka from date to todate wise amount kese find out kare vlookup se
Jaise ki..? Ques format bataiye . umesh Ji..phir krte h solve apke doubt ko
Sir below format 👎
Name----From Date-----To Date---Amount.
Exp--Amit---12 Apr---25 Apr--9,000.
This Type more than data on excel sheet,
Sir I need name with period wise amount details on vlookup formula. how to find out sir please help me.
sir directo link kyo open nahi hota , agar ye open hota to or bhi easy ho jata
Saqib sahab saare link broken ho gye hain don't know why..main uspe kar rha hu dheere dheere update..kuch tike dijiye krne lgega kaam
Sir choose({1,2}) ye braces yaha kyu lagate h and iska logic kya hai?
{} house of array hai ye kab group member lena hoga to ye lgega..aap Array and sumproduct ke tutorial padehm.pehle
00:52 or 2:31
5:56 or 8:40
Hi Sir, I hope You are fine.
Sir we can solve 3 table question this formula also. =IF(A7="SAMSUNG",VLOOKUP(B7,$F$4:$G$7,2,1),IF(A7="NOKIA",VLOOKUP(B7,$F$11:$G$14,2,1),IF(A7="APPLE",VLOOKUP(B7,$F$18:$G$21,2,1),"DATA NO GIVEN"))).
👍
Link file is not available
Kindly find assignment master folder for all playlist assignment
Table to dekh hi nhi raha third wala
To kya table lege
Oh.. editing me issue hoga.aap file download kariye assignment master link se phir practice kriye
Helper hi laga lenge
Aaj koi interview ka jugad hua ya nahi..?
♥️♥️🙂🙂
Sir don't know hindi
We kw telugu how sir ur saying bt cnt understand do u telgu
Dear Ramya,It's Complete hindi Mis tutorial step by step learning. Sorry dear I don't know Telgu
Choose मे अलग अलग reference n देना पड़े इसका कोई तरीका है
poor example, this is best done with index and match
Kindly watch complete series first ..may be indirect is better option😊
on what basis are you saying that?@@Innozant
@@arunmm4777 Dear Arun everything we are learning will make.you to the same destination,Choose which one thrills you most.
After watching Indirect series you may able to understand that Indirect is much better than any lookup series function.😊
Thanks sir
Excellent sir
Thanks dear👍❤️
excel vlookup 0 and 1 exject
match . what iS meaning ????