Excel CHOOSE FUNCTION | How to use VLOOKUP with Choose Function without Helper Column | Hindi

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.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#chooseformula #excelchoosefunction#Innozant #excelformulasandfunction

[@sandeepaswal8944]

पर्नाम सर जी। सर मजा आ गया यै concept shikhkar आपने बहुत ही खूबसूरत तरिकै सै describe करा। You are Great. You are my favourite teacher.

[@Innozant]

Thanks Sandeep.Have a great day🙏♥️

[@tejpalsain1507]

Thanks sir. आपके वीडियो का हमेशा इंतजार रहता है, क्योंकि आप हमेशा कुछ न कुछ नया और रोचक लेकर आते हो। Choose fucntion का इतना बढ़िया use आपके वीडियो में ही देखने को मिला। बहुत बहुत धन्यवाद।

[@Innozant]

Thanks Tejpal Ji🙏♥️🙂

[@1gopalakrishnarao]

Excellent. very informative, useful. Thanks on behalf of all Excel users/learners/addicts for doing a great job indeed.

[@Innozant]

Than Gopala Sir for such a wonderful feedback.🙏♥️🙂

[@jayantapaul7335]

Apko Dil se "SALAM"।

[@vickycivil83]

thank you very much sir. aap ki video dekh k mera kaam ban gya. thank you again.

[@Innozant]

Thanks Vicky Ji

[@RahulYadav-yt4jn]

Salute sir 🙏.I learnt a lot from your videos.

[@user-iv2lh7gk1l]

Thank You

[@VimalKumar-ih6ik]

You are really great

[@K-Starreaction]

Superb sir

[@alokeshsarkar336]

This is the most valuable vedio for me. Thank you Thank you & Thank you

[@Innozant]

Thanks Alokesh..Happy Learning dear👍🙏❤️

[@DipuKumar-tx8lo]

Superb work Sir, Your all videos are too clear and informative to learn.

[@Innozant]

Thanks dear .Keep learning ❤️

[@MANOJKumar-bz9lp]

Excellent

[@pramodbhavsar4488]

Very nice video vlookup & chose function formula thank you and Happy vijayadashmi

[@Innozant]

Thanks Pramod Ji..Same to you dear🙏♥️🙂

[@datascale4043]

your knowledge is Excellent Sir

[@Innozant]

Thanks Dear❤️🙏👍

[@dhakafady774]

thanks a lot sir

[@punesh195]

Sir yee sumifs se bhe nikl jayega

[@vishalbhati912]

Bahot badiya

[@AnilKumar-is8cr]

You learn all in a good method and choose a good subject.

[@Innozant]

Thanks Anil Ji❤️

[@rahulram3360]

Thanks sir

[@kkrcreationstatus6583]

Thanks a lot, SIR You worked hard for us. Hats off

[@Innozant]

❤️❤️👍

[@asimali5820]

Good one!

[@Innozant]

Thanks Asim Sahab..Happy learning

[@shyamallrounder]

Bahut pratice karni padegi iski..

[@Innozant]

Yes...Do practice on regular basis

[@balkrishnavengurlekar8520]

Sir teaching excellent

[@Innozant]

Thanks ❤️

[@johndas8173]

Sir vlookup wirh offset formula using apply sir is topic par video banao

[@nehajoshi8780]

Thankyou Sir...great!🙏

[@bhoopendraraghav9781]

Very very useful concept

[@Innozant]

Thanks Bhoopendra ji.gn.🙏♥️

[@kinghundred]

very excellent sir

[@puransingh-sx2tk]

Thank you for sharing your knowledge guru g

[@Innozant]

Thanks Puran.Keeo supporting 🙏♥️

[@vijaysahal4556]

very useful sir 👍🏻👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay ji

[@alihyder9250]

Loves from Pakistan ❤❤❤

[@AJ-The_Nature_Lover]

Great knowledge 👍

[@Innozant]

Thanks Ajay ji

[@hemantgusain1260]

Thanks you sir, choose is really interesting and useful formula.

[@Innozant]

Thanks Hemant Ji..GN.🙏♥️

[@brijeshshah574]

Excellent 😊🙌🔥👌

[@tannupathak4554]

Sir vlookup+choose horizontal table pe bhi chalta hai kya

[@rhashmi1]

Very nice.

[@tarunsehgal5789]

Excellent sir

[@Innozant]

❤️❤️❤️ thanks

[@devenderkumar1220]

excellent👍

[@sarthakbhagu707]

Nice very useful sir ji

[@Innozant]

Thanks Sarthak Sahab🙏♥️

[@vijaybhandari1693]

great one

[@atulshukal4072]

Very good Sir ji

[@Innozant]

🙏♥️

[@sadguru1400]

Thank you for such an excellent video, it helps a lot:)

[@Innozant]

Thanks

[@abhishekjadli1566]

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?

[@Innozant]

Jitna depth me aayega wo achi baat hai na dear

[@beingradhey]

Make video on IF+CHOOSE function

[@Innozant]

👍

[@AbhishekMishra-lh3jw]

Sir agar isme multiple table ho or range fix nhi ho to....plss sir help me ......

[@gauravbhatia7987]

Thnq sir

[@Innozant]

👍🙏❤️

[@satishojha6240]

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.

[@Innozant]

Thanks.There is no need to use seprator as it's not mandatory ,We are using this just for our convenience.Good Night

[@mithleshsharma5561]

Reverse vlookup bata dijiye sir

[@shrikantbadge3978]

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?

[@AbhishekMishra-lh3jw]

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

[@Innozant]

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

[@AbhishekMishra-lh3jw]

@@Innozant tqqq so much

[@naveenrana239]

thank you so much sir it will help.:-)

[@Innozant]

Thanks Naveen ji❤🙏

[@ShyamSundar-mn4vm]

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)

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@NandKishor-jm1td]

Hi sir please i want to learn dynamics function So pls share dynamic formulas question

[@anmoljangid551]

How to use vlookup when lookup value is formula

[@Yourrajivmahajan]

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

[@Nityabhagattvshow]

i have one question if i don't want create " Samsung 1, Nokia 2 and Apple 3 " Table Then How do solve please reply

[@Innozant]

Dear solution is already there in example before I explain this example 🙏

[@NandKishor-jm1td]

I want to learn vlookup with indirect or match

[@krishnayadav-bq4jg]

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.

[@Innozant]

Ok..Give me time. will make video for the same.

[@madurgababueducationS60]

excel vlookup 0 and 1 exject match . what iS meaning ????

[@TheVoiceOfPeople-]

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

[@Innozant]

@innozantofficial telegram id

[@Harish.Prasad.Semwal]

00:52 or 2:31 5:56 or 8:40

[@horrorlovestories]

Sir helper column ke saath reference error aa raha hai 2:20 pe aur without helper column pe exact values aa raha hai

[@sukhbirpuniaeasyenglish4733]

Sir ye freeze kaise or kaha karte hai.. Iskho thoda bataiye...

[@Innozant]

Basic excel playlist me Formula reference ke videos dekhen. Aapke saare doubt freeze krne se related clear honge

[@ishutiwari5567]

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 .

[@ishutiwari5567]

sir answer mil gya indirect series me 🙏😊

[@Innozant]

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

[@ishutiwari5567]

@@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🙏😊

[@Innozant]

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 KZbin platform par upload Kar rha hu❤️🙏

[@ishutiwari5567]

@@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 🙏😊

[@msports4522]

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"))).

[@Innozant]

👍

[@unboxingreviewvlog7009]

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.

[@Innozant]

@innozantofficial telegram id..yahan bhejen sheet..will see

[@unboxingreviewvlog7009]

@@Innozant solved!!!! Iferror(vlookup(match(vlookup). With these functions got the result.

[@aaqibchaudhary786]

sir directo link kyo open nahi hota , agar ye open hota to or bhi easy ho jata

[@Innozant]

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

[@sagarmathur3535]

Sir choose({1,2}) ye braces yaha kyu lagate h and iska logic kya hai?

[@Innozant]

{} house of array hai ye kab group member lena hoga to ye lgega..aap Array and sumproduct ke tutorial padehm.pehle

[@devendergusain8974]

isme INDEX+ MATCH nhi chal skta kya sir ." mohit" and "unit test" vale question mein

[@Innozant]

HAn usse bhi ho skta h

[@mohammedalansi6446]

{1;2}does not work with excel 2019 what is the alernative to define array input

[@Innozant]

Why..? Therr is no issue in array formula ik excel 2019..whats prov you are facing now

[@mohammedalansi6446]

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

[@shikhabhardwaj8626]

Sir, some issue in googlesheet with this formula. Kindly help.

[@Innozant]

Hi Shikha..kindly share your query..@innozantofficial telegram id

[@ROHITKUMAR-te9pk]

Table to dekh hi nhi raha third wala To kya table lege

[@Innozant]

Oh.. editing me issue hoga.aap file download kariye assignment master link se phir practice kriye

[@umeshsahu735]

Sir kisi person Ka from date to todate wise amount kese find out kare vlookup se

[@Innozant]

Jaise ki..? Ques format bataiye . umesh Ji..phir krte h solve apke doubt ko

[@umeshsahu735]

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.

[@awesshaikh716]

Aaj koi interview ka jugad hua ya nahi..?

[@Innozant]

♥️♥️🙂🙂

[@Vats-Technical]

Link file is not available

[@Innozant]

Kindly find assignment master folder for all playlist assignment

[@raselsheikh9982]

Thaaaaaaaaaaaaaaaaaaaaaaaaaaaanks I

[@Innozant]

Thaniks Rasel Sheikh Sahab.have a njce day

[@raselsheikh9982]

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

[@rajrawat287]

Helper hi laga lenge

[@ramyakudikala8117]

Sir don't know hindi We kw telugu how sir ur saying bt cnt understand do u telgu

[@Innozant]

Dear Ramya,It's Complete hindi Mis tutorial step by step learning. Sorry dear I don't know Telgu

[@uniquemobiletipstricks7714]

Choose मे अलग अलग reference n देना पड़े इसका कोई तरीका है

[@arunmm4777]

poor example, this is best done with index and match

[@Innozant]

Kindly watch complete series first ..may be indirect is better option😊

[@arunmm4777]

on what basis are you saying that?@@Innozant

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

[@dineshthakare7627]

Thanks Sir

[@Rejuanhaque]

Excellent sir

[@Innozant]

Thanks dear👍❤️

[@madurgababueducationS60]

excel vlookup 0 and 1 exject match . what iS meaning ????

[@anshitharajan6752]

Thank u sir

[@Innozant]

Thanks dear