Excel CHOOSE FUNCTION - Things you are allowed to lookup | Part-2 Hindi

Learn Choose Function Concept and "Things you are allowed to lookup in choose function.
1. Lookup Cell References
2. Lookup Range
3. Lookup defined names
4. Lookup Array Constant
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 #exceltutorial #misinterviewquestions

[@ManishVerma-gg8xl]

कितना आसान है अगर concept clear है तो बच्चो वाला खेल खेल रहे है हम' क्या बात कही सर आपने बहुत सही कहा और बहुत ही शानदार topik सिखा रहे हो आप और हाँ एक बात और आपके lookup series के सभी वीडियो एक सीरीज से कम से कम रिपिट करके 2 से 4 बार जरुर देखता हु consepte और ज्यादा clear हो जाता है एक बार फ़िर से बहुत बहुत आभार आपका 🙏🙏🙏

[@Innozant]

Thanks Manish ji❤️❤️

[@gurpalsingh1897]

asa lagta hai jaise excel ki khoj aap ne ki ho.....Hats off..

[@Innozant]

Hahahaha.. Thanks Gopal ji..keep exploring ❤️

[@mohitsharma-ym3km]

Sir aapka content itna jabardast kaise hota hai. Actually jab me kisi function per KZbin video dekhta Hoon toh most of them sirf halka fulka samjhate hai but aapka content bhut deep hota . Aap saara part cover Kar dete ho. Aapki video dekhne ke baad dusri video dekhne ki jaroorat nhi padti. Sach me you're the best teacher. Thank you so much sir 😊

[@Innozant]

Lots of love Mohit❤️🙏for such a valuable feedback.Apne to sachme aaj aur mehnat krne ,Acha content deliver Karne ke liye motivate kar Diya.Thnks

[@deenabandhudevasthanam6545]

Exactly....Its very true. After seeing your videos...I have stopped watching other videos...very beautiful...each & every topic.....Hats off - Anil

[@PavanKumar-cm2sz]

Sir ji aisa jaadoo.......achhe achhe tuber walo ki Aankhe😱 khol ke rakh dega..... Wahhh ji waahhh 😘😘😘🤗

[@Innozant]

Thanks Pavan for such a lovely comment.Umeed hai aapko aaja ka choose function part 2 ka use samajh aaya hoga aur ap practice bhi karenge

[@imon2065]

sir, apka videos se humare kitne fayda ho rahe he ye ap soch v nahi sakte. Main BD se hu or har roz ofc se ane k baad apka tutorials dekhta hu. May Allah bless u and make you fit for your good works

[@Innozant]

Thanks Kazi..Keep learning ❤️❤️👍

[@imon2065]

@@Innozant you r most wc sir.. ins sha Allah I'll

[@Learn_withkd]

Ekdam gjb padhte ho sir mja aa jata hai tooo good sir ji .....👍👍👍👍👍👍👍👍👍👍👍

[@Innozant]

Thanks

[@shrikantbadge3978]

सहारा मिले तो क्या कूछ नहीं कर सकते. True sir. Your videos are my motivation and support.

[@Innozant]

Veey True Shrikant❤️🙏 Thanks 🙏🙏

[@deenabandhudevasthanam6545]

Very beautiful...Easily understandable... No confusion...It inspires us to learn more. Its amazing. I dont want to watch other videos..Like to learn through your videos only...Thanks a lot .. Namaste ji Anil from Bangalore

[@Innozant]

Love you Anil ji for such a valuable appreciation dear...Really means a lot to me,Hope these step by step in sequence complete course tutorial ads some value in your life.

[@All_about_motivation969]

Aa gaya aa gaya. Sir ji samajh aa gaya mere ko. Aapka bohot bohot dhanyawad sir. Mai choching jata hu or mere vaha pe choose chal raha hai or mere ko khuch bhi samajh nahi aaya tha. Magar maine aapki video dekh kar sab ek damm aache se samajh aa gaya.

[@Innozant]

👍👍❤️❤️❤️

[@satishmestry5687]

Nice explanation. Har 1 concept bahut hi acchese clear hote ja rahe hai. you are a great teacher sir.

[@Innozant]

Thanks dear❤️god bless you

[@niteshmandal5816]

Sir g ye video dekhne ke baad hume samjh aa gye ki is se pahle vlookup me helper column lene parte the jab do lookup value hote the Ab nhi lene parenge 🙏 choose ka gajab use 🫡

[@prakashchaudhari8444]

Liked all your VLOOKUP videos

[@RMKserve]

You are super hero of excel

[@Innozant]

Thanks Raja

[@satishojha6240]

All days your video inspired me . Smoothly define the concept of vlookup with choose thanku very much sir.Good night

[@Innozant]

Thanks Satish Ji,I really like your dedication.I always seen your comment as well.God bless you..♥️🙂👍GN

[@shivammishra-bf6vp]

God father of excel 🎉🥳🥳♥️♥️ Please like and share his videos as much as you can.

[@Innozant]

Thanks Shivam..Keep learning ❤️😊

[@swagatamkhanra4667]

Thank u sir,,this is a very beneficial to all of us,, thank u sir dil se

[@Innozant]

Thanks dear

[@swagatamkhanra4667]

@@Innozant sir plz make a video on conditional formatting overall..♥️

[@sandeepaswal8944]

सर आपने vloolup+ choose function का बहुत ही सुन्दर ज्ञान दिया। यै बहुत ही नया था मेरै लियै । धन्यवाद आपका सर जी। सर आप vlookup large data पर भी एक video जरुर लेकै आना ।

[@Innozant]

Thanks Sandeep ji🙏❤️🙂

[@1gopalakrishnarao]

Excellent. interesting with examples. You have explained the advantages of Choose. Thank you.

[@Innozant]

Thanks Gopala Sir,Hv a nice day🙏♥️

[@pankubisht3495]

U are great sir and master of excel

[@Innozant]

Thanks Panku❤️🙏

[@vikasgawaria5330]

Nice video sir thankyou and good evening

[@yashpatil3375]

Excellent sir ji 🙏🏻🇮🇳 Aapko to google ki Excel team me hona chahiye tha, but fir hme kon samjhata ye formulas 👍🇮🇳

[@aamirmasood4655]

Buht Zabardast Bhai jan,

[@ghanshyamayodhyaprasadgupt727]

before your channel i refer learn more channel by mr. satish dhawale sir. after watching your too many vedios i refer your channel to my friends

[@Innozant]

Thanks dear..Learn step by step in sequence from Basic to advanced series with Assignment master for practice available in video description.

[@hemantgusain1260]

Thanks you sir, I got to know real use of choose function.

[@Innozant]

Thanks Hemant ji..Hope you like the real.implementation of choose

[@somnathde5143]

Very helpful video. Sir please make a video for students result grade (A,A+,O, B,....) calculation using choose function or any look up value

[@shrikantbadge3978]

Amazing Sir. Thanks

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@Innozant]

Thanks Rahul

[@puransingh-sx2tk]

Choose ka best use kese karna hai aaj pata chala 👌👌👌👌🙏

[@Innozant]

Thanks Puran..Conceptually Seekhiye jo bhi seekhna hai..life me kbhi nahin bhulenge.♥️🙏

[@zaheersiddiqui3812]

Thank you boss !

[@sarthakbhagu707]

Wow sirji great

[@Innozant]

Thanks Dear🙏♥️

[@Anony15100fd]

Sir multiple me vlookup se value uthane ke liye vlookup + if bhi use kar sakte hai

[@RahulChauhan-ll9pu]

Very helpful sir.

[@Innozant]

Thanks Rahul Ji🙏♥️

[@kinghundred]

very excellent sir

[@rhashmi1]

Excellent!

[@Innozant]

Thanks Rashid Sahab ❤️

[@ghanshyamayodhyaprasadgupt727]

super sir

[@kmanoj392]

Nice sir

[@Harish.Prasad.Semwal]

1:28 2:36 4:54 or 6:57 9:57 11:34* * Choose formula generated the below table to assist vlookup formula: AB Samsung BB Sony CV Nokia DQ Moto

[@ganeshgupta4279]

It may be possible with index and match

[@Innozant]

😊👍

[@msports4522]

Hi! Sir 3 table question I have solved with Index reference. Is it ok or need to do it with Choose function? Thanks.

[@Innozant]

Index is fine

[@johndas8173]

Sir vlookup with offset formula is topic par video banao

[@shwetkumar1719]

Sir array me hm tb lenge na jb naming rage kia hua hoga tb na? Sir App Array me range lia to fir coloum or range q nhi lia?

[@skdaveskdave9798]

thanks

[@Innozant]

🙏

[@gauravbhatia7987]

Thnq sir

[@Innozant]

👍😀

[@indranilsarkar4046]

Sir, Samajh meain agaya, ye jo house array or constant array hain, ye "{ }" Individual tables are shown as one or single tables. Am I right Sir?

[@johndas8173]

Sir vlookup with offset formula is topic par video banao this video add vlookup with offset formula

[@Alankriti_Sr]

hi sir , if there is no developer tab in excel , what to do?

[@muhammadwaseem70]

sar main ny time calculate karna hai matlab (6:00am sy (7:00am) (10:00am)(11:00am)ye sab ak sath sum kary main ny ye farmula lagya hai =B1-A1+C1-A1+D1-A1 ye sum to karta hai par agr koi khali rakhun to wo time - kar deta hai plz koi farmula baty agr do kalum main time likhun to wo sum ho jay ak khali b hoto wo - na ho matlab jo time sum hota hai us main sy ak khali ka 6 hars - ho jata hai

[@Innozant]

Jo cell blank ho use condition paas karke null hi rehne do otherwise jis cell me value hai use sirf sum kar lo

[@muhammadwaseem70]

Sar main ny time bad main intar karna hota hai is liy khali b rakhna hai plz help me

[@indranilsarkar4046]

Sir, where is problem in this formula"VLOOKUP(E1, $A$2:$A$5&$B$2:$B$5:$C$2:$C$5, 2, 0)" and why the result shown as first column value with Third Column Value. For example I have input the value i.e. "dq", and the output has shown "DMoto"?

[@shwetkumar1719]

sir kya esko index se kr sakte hai?

[@Innozant]

Haan..index se bhi kr skte h.. attempt bkrke btana aap

[@kalwantsingh4997]

👌

[@RahulKumar-ly6ly]

Sir excel me show margne vala option ko clicks karka manual margne set kaise karta ha sir margne vali line ko aaga piche kichker sir es topic par ek video pĺease sir

[@SAJJADAHMAD-uy3hu]

clicking on direct link I am not redirected to practice workbook.

[@bishtlokesh1297]

First view❤️

[@nishachauhan9103]

Vedio time at 11:19 me aapne ctrl +shift+enter use kyu nahi kiya

[@Innozant]

Yes Nisha wahan ctrl shift enter ki jrurs hi nhi gsi kyunki Direct memory me insert kiya hai data na ki range liya hai, i mean ydi range lenge data ka(eg. b2:b9) to aap ctrl shift sur enter press krenge as it is array but app ydi khudse array {gold,1,silve,2} id tareeke se paas krenge to sirf enter press kyunki apne direct array bnaya h memory insertion.❤🙏

[@sukantashil7570]

Sir during calculating shipfee by second method, I am not able to understand how the nested vlookup returns number i.e index number for Choose fn. Sir, can you please elaborate?

[@shivammishra-bf6vp]

Sir isme approximate match ku, why not exact match ???

[@pawanwakale8801]

sir example me try kiya toh kuch jagah par #N/A aa raha final output me

[@skdaveskdave9798]

Congratulation तो किया धन्येवाद आपने silver choise value1, value अधूरा बताया है वह पूरा करो हम bigner है

[@Innozant]

Sir aap choose ke videos start se nhi dekh rahe hain isloye nhi aa raha hai samajh..vlookup video playlist me jaake choose ke video concept start se dekhen..maine basic se karaya hai ek ek steps choose function ke.

[@ublogs]

HI! YOU HAVE EXPLAINED IN A VERY INTERESTING MANNER. BUT I HAVE A QUESTION FOR YOU ON XLOOKUP. SUPPOSE YOU HAVE CREATING A TABLE AND IT HAS THREE COLUMNS IST COLUMN CONTAINS SERIAL NUMBER FROM 1 TO 10 SECOND COLUMN CONTAINS NAME IT HAS TEN NAMES BUT TWO OR THREE NAMES ARE REPEATED LIKE RAM REPEATED FOR THREE TIMES. THIRD COLUMN HAS FATHER NAME. IN THIS COLUMN TEN DIFFERENT FATHER NAMES HAVE BEEN GIVEN NOW, IN NEW CELL SAY F1 VIA DROP DOWN LIST OR MANUAL TYPING OF SERIAL NUMBER WE NEED NAME IN F2 CELL AND FATHER NAME IN F3 CELL. IS IT POSSIBLE USING XLOOKUP? IF YES THEN PLEASE GUIDE. THANKS.

[@Innozant]

kindly share your query with explanation.. [e-mail]

[@ublogs]

@@Innozant PLEASE CHECK YOUR E-MAIL

[@kiranbandekar2434]

Bahut Achha Sir ji.. Choose Aur MID Left Right Ka Estemal Karke Sir ji..Numbric value ko Kaise wirds me Indian Rupeese me Kaise Covert kare eska 1 Video Bana dijiye.. Jaise ki Sir 1 Formula Bada Mera Paas Hai.. Lekin usme Million Aur doller hai .. Lakh me nahi aa raha hai ="Rupees " &CHOOSE(LEFT(TEXT(B3,"0000000.00.00"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")&IF(--LEFT(TEXT(B3,"000000000.00"))=0,,IF(AND(--MID(TEXT(B3,"000000000.00"),2,1)=0,--MID(TEXT(B3,"000000000.00"),3,1)=0)," Hundred"," Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000.00"),2,1)1,CHOOSE(MID(TEXT(B3,"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(B3,"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))&IF((--LEFT(TEXT(B3,"000000000.00"))+MID(TEXT(B3,"000000000.00"),2,1)+MID(TEXT(B3,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(B3,"000000000.00"),4,1)+MID(TEXT(B3,"000000000.00"),5,1)+MID(TEXT(B3,"000000000.00"),6,1)+MID(TEXT(B3,"000000000.00"),7,1))=0,(--MID(TEXT(B3,"000000000.00"),8,1)+RIGHT(TEXT(B3,"000000000.00")))>0)," Million and "," Million "))&CHOOSE(MID(TEXT(B3,"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")&IF(--MID(TEXT(B3,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(B3,"000000000.00"),5,1)=0,--MID(TEXT(B3,"000000000.00"),6,1)=0)," Hundred"," Hundred and"))&CHOOSE(MID(TEXT(B3,"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety")&IF(--MID(TEXT(B3,"000000000.00"),5,1)1,CHOOSE(MID(TEXT(B3,"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(B3,"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen"))&IF((--MID(TEXT(B3,"000000000.00"),4,1)+MID(TEXT(B3,"000000000.00"),5,1)+MID(TEXT(B3,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(B3,"000000000.00"),7,1)+MID(TEXT(B3,"000000000.00"),8,1)+MID(TEXT(B3,"000000000.00"),9,1))=0,--MID(TEXT(B3,"000000000.00"),7,1)0)," Thousand "," Thousand and "))&CHOOSE(MID(TEXT(B3,"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")&IF(--MID(TEXT(B3,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(B3,"000000000.00"),8,1)=0,--MID(TEXT(B3,"000000000.00"),9,1)=0)," Hundred "," Hundred and "))&CHOOSE(MID(TEXT(B3,"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")&IF(--MID(TEXT(B3,"000000000.00"),8,1)1,CHOOSE(MID(TEXT(B3,"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(B3,"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))&" only "

[@Innozant]

😀OK banate hain ek video is topic par

[@kiranbandekar2434]

thanks sir..ji

[@indranilsarkar4046]

Sir, actually I cannot undertand this "{1, 2}" code

[@indranilsarkar4046]

In single index number I can visualize but incase of {1,2} I cannot understand

[@indranilsarkar4046]

I cannot be visualized

[@indranilsarkar4046]

Sir, Samajh meain agaya, ye jo house array or constant array hain, ye "{ }" Individual tables are shown as one or single tables. Am I right Sir?

[@nehathadani8118]

hello, I tried the same with Index and Match functions but it didn't work (I tried providing the reference of the array in different sheets) =INDEX((Gold!$B$3:$B$7,Silver!$B$3:$B$7,Basic!$B$3:$B$7),MATCH(C40,Gold!$A$3:$A$7,1),,MATCH(B40,$D$49:$D$51,0)) Can you please help? Thanks.

[@AlimKhan-bl5sh]

Sir ye.. Topic bounce gaya h.. Samjh nahii aya.. Ho kya gaya.. Iss video k example me😢😢

[@Innozant]

Vidro repear kariye phir se..aayega samajh

[@AnuragSingh-w7g]

आप ज्ञानी हो

[@shwetkumar1719]

nhi kr pa rha sir Index se

[@Innozant]

Ok .add kr dunga kisi video me ye

[@shwetkumar1719]

@@Innozant ok sir

[@shwetkumar1719]

Koi hint dejeya na try krta hu

[@himanshukesarwani1619]

it is mandatory that all those tables have to be of exact size(I mean rows and columns)??? @innozant #innozant please reply

[@skdaveskdave9798]

मेने Silver मे choose मे मार खा गए इसमे अधूरा रखा है दूसरा vlookup pass होगया कृपा फिर से समजाए

[@Innozant]

Choose ke videos start se dekhen ek baar..kahan samajh aane me issue aaraha hai batayen.will guide you.

[@Innozant]

Aap vlookup.playlist me jake choose ke in sequence video dekhen..aayega samajh easily

[@tejpalsain1507]

Great sir jee.

[@Innozant]

Thanks Tejpal♥️👍🙏

[@johndas8173]

Sir vlookup with offset formula is topic par video banao

[@johndas8173]

Sir vlookup with offset formula is topic par video banao this video add vlookup with offset formula

[@johndas8173]

Sir vlookup with offset formula is topic par video banao this video add vlookup with offset formula

[@johndas8173]

Sir vlookup with offset formula is topic par video banao this video add vlookup with offset formula

[@johndas8173]

Sir vlookup with offset formula is topic par video banao this video add vlookup with offset formula

[@johndas8173]

Sir vlookup with offset formula is topic par video banao this video add vlookup with offset formula

[@johndas8173]

Sir vlookup with offset formula is topic par video banao this video add vlookup with offset formula