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

[@gurpalsingh1897]

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

[@Innozant]

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

[@Learn_withkd]

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

[@Innozant]

Thanks

[@prakashchaudhari8444]

Liked all your VLOOKUP videos

[@RMKserve]

You are super hero of excel

[@Innozant]

Thanks Raja

[@vikasgawaria5330]

Nice video sir thankyou and good evening

[@aamirmasood4655]

Buht Zabardast Bhai jan,

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

👍👍❤️❤️❤️

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@Innozant]

Thanks Rahul

[@kalwantsingh4997]

👌

[@zaheersiddiqui3812]

Thank you boss !

[@sarthakbhagu707]

Wow sirji great

[@Innozant]

Thanks Dear🙏♥️

[@ManishVerma-gg8xl]

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

[@Innozant]

Thanks Manish ji❤️❤️

[@shrikantbadge3978]

Amazing Sir. Thanks

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

[@ghanshyamayodhyaprasadgupt727]

super sir

[@kmanoj392]

Nice sir

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

[@gauravbhatia7987]

Thnq sir

[@Innozant]

👍😀

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

[@skdaveskdave9798]

thanks

[@Innozant]

🙏

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

[@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..♥️

[@shrikantbadge3978]

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

[@Innozant]

Veey True Shrikant❤️🙏 Thanks 🙏🙏

[@pankubisht3495]

U are great sir and master of excel

[@Innozant]

Thanks Panku❤️🙏

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

[@johndas8173]

Sir vlookup with offset formula is topic par video banao

[@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.♥️🙏

[@rhashmi1]

Excellent!

[@Innozant]

Thanks Rashid Sahab ❤️

[@johndas8173]

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

[@shivammishra-bf6vp]

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

[@Innozant]

Thanks Shivam..Keep learning ❤️😊

[@kinghundred]

very excellent sir

[@RahulChauhan-ll9pu]

Very helpful sir.

[@Innozant]

Thanks Rahul Ji🙏♥️

[@ganeshgupta4279]

It may be possible with index and match

[@Innozant]

😊👍

[@Anony15100fd]

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

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

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

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

[@yashpatil3375]

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

[@Alankriti_Sr]

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

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

[@sandeepaswal8944]

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

[@Innozant]

Thanks Sandeep ji🙏❤️🙂

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

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

[@shwetkumar1719]

sir kya esko index se kr sakte hai?

[@Innozant]

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

[@AnuragSingh-w7g]

आप ज्ञानी हो

[@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"?

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

[@SAJJADAHMAD-uy3hu]

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

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

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

[@shivammishra-bf6vp]

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

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

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

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

[@pawanwakale8801]

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

[@1gopalakrishnarao]

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

[@Innozant]

Thanks Gopala Sir,Hv a nice day🙏♥️

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

[@KailashChand-vg2fq]

Sir agar mere paas do lookup hain (emp ID & Emp. Name) main chahta hun ki main id se bhi lookup kar lu yaa name se lookup kar lo. Aur agar name select karein to uski id aa jaye aur id select karu to name aa jaye. Please give me solution. I need it urgent.

[@Innozant]

Double vlookup ka video dekhen.akready bataya hua hai If(isnumber(a1),vlookup for num,vlookup for text)

[@KailashChand-vg2fq]

Sir maine abhi aapka double vlookuk dekha. But mujhe solution nahin mila My question is mere paas ek table hai jisme emp. ID, emp. name, designation aur salary hai. Main agar id ko lookup value rakhu to bhi mujhe designation aur salary aa jaye Aur agar naam ko lookup value manu to bhi yeh dono aa jaye

[@KailashChand-vg2fq]

Aur agar ID likhu to automatically name aa jaye aur name likhu to id aa jaye

[@KailashChand-vg2fq]

Please give me solution sir,

[@Innozant]

Whi to bataya..chrck kara lijiyr pehle hi if ke saath istext ya isnumber se..uske basd par vllookup chala lijiye

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

[@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.❤🙏

[@bishtlokesh1297]

First view❤️

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

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

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

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

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

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

[@himanshukesarwani1619]

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

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

[@tejpalsain1507]

Great sir jee.

[@Innozant]

Thanks Tejpal♥️👍🙏

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