VLOOKUP with Multiple Sheets in Ms-Excel Telugu || computersadda.com

Поделиться
HTML-код
  • Опубликовано: 2 ноя 2024

Комментарии • 125

  • @Computersadda
    @Computersadda  4 года назад +7

    Above Topic Excel Format File Link below :-
    ----------------------------------
    www.computersadda.com/2020/03/x-lookup-function-in-ms-excel-practice-file/
    =================

  • @lakshmivasavi8432
    @lakshmivasavi8432 4 года назад +2

    Very useful video who works in excel sheets

  • @karimnagarian2776
    @karimnagarian2776 Год назад

    Your explanation with that level of patience just blow my mind👍

  • @vamshilatha-t1n
    @vamshilatha-t1n 6 месяцев назад

    Thanks anna Mee videos chusi nen vlookup nerchukunttumnanu

  • @Pavanisontyana
    @Pavanisontyana 11 месяцев назад

    Very useful information. Thank you so much for sharing with us sir ❤

  • @GangaS0143
    @GangaS0143 3 месяца назад

    Thank you for your explanation sir, it's successful work for me

  • @mudemadhu9898
    @mudemadhu9898 2 года назад

    How to apply formulas pls oka video cheyandi sir..me classes carrier build చేయడానికి చాలా use అవుతుంది సిర్ తనకు

  • @shyamalarajeshpolimera6363
    @shyamalarajeshpolimera6363 4 года назад +3

    Excellent coaching

  • @RaghoooVTech
    @RaghoooVTech 3 года назад +2

    Your explanation is really good.. i like it.. Tq

  • @syedabdulwaheed6436
    @syedabdulwaheed6436 Месяц назад

    Plz make a video on how to make credit card entries in tall erp 9 and shares purchase and sale
    Thanks

  • @bramesh6918
    @bramesh6918 2 года назад

    Focus gurinchi explain chayandi.

  • @Lovebeatzs_mahema
    @Lovebeatzs_mahema Год назад

    Thank s for your information sir but
    We need to do multiple sheets in same data how to identify please explain sir 🙏

  • @rakeshkompalli904
    @rakeshkompalli904 3 года назад

    Thanks Anna nee valla job ki chances perigayi

  • @nagarjunakomma7501
    @nagarjunakomma7501 4 года назад +1

    Thanks for the this video sir pivot table pina oka video sir...

  • @bhagyalaxmikallula6661
    @bhagyalaxmikallula6661 2 года назад

    Sir,if you possible could you do one more vedio about vlookup n how to do vlookup formula from other sheet n how to remove duplicates...

  • @venkatasundeep7670
    @venkatasundeep7670 3 года назад +1

    Excellent bro.....

  • @durgamanasa1420
    @durgamanasa1420 2 года назад

    THANKYOU FOR DOWNLOADED FILES

  • @vamsikrishna7550
    @vamsikrishna7550 3 года назад

    Very good information video. Thanks 🙏

  • @killisimhachalam5178
    @killisimhachalam5178 2 года назад

    Sir naku oka dout
    Direct ga Direct applychesta saripodni kadha

  • @SumatriChannel
    @SumatriChannel 2 года назад

    thank you good explanation sir

  • @soujanyabommena182
    @soujanyabommena182 2 года назад

    Excellent sir ... Tq u sir

  • @yogeshwarreddy2808
    @yogeshwarreddy2808 2 года назад

    wow.......what an explanation

  • @kumarjJ-op7pu
    @kumarjJ-op7pu 6 месяцев назад

    Excellent sir.

  • @vaibesb4u
    @vaibesb4u 2 года назад

    Very useful man

  • @munisaimechanical3087
    @munisaimechanical3087 4 года назад

    Bro,
    Your explanation was damn good.

  • @akhilkumar_Official
    @akhilkumar_Official 2 года назад

    excellent video 👌👌👌

  • @cutedevi4120
    @cutedevi4120 4 года назад +1

    Thanks you so helpful

  • @princemjprasanth8954
    @princemjprasanth8954 3 года назад

    Thanks for the helpful video Sir.

  • @maheshabbagoni4851
    @maheshabbagoni4851 2 года назад

    Thank you so much sir

  • @bhanumurthy100
    @bhanumurthy100 3 года назад +1

    Super

  • @kranthij3561
    @kranthij3561 4 года назад

    Tq a lot, waiting for this video from long time.
    Finally I got this video

  • @mantripragadaseshu5785
    @mantripragadaseshu5785 2 года назад

    SIR WHEN WE are using initially if statements it is coming as very few arguments are used

  • @nagasrinu1552
    @nagasrinu1552 2 года назад

    If first column is emp name instead of emp no what we should provide in formula after lessthan or equal to

  • @gurijalasandeep2293
    @gurijalasandeep2293 2 года назад

    Waiting for c language sir.

  • @ramakrishnabonthu1287
    @ramakrishnabonthu1287 2 года назад

    Hlookup gurinchi full video kavalisir

  • @Madhutatipamula
    @Madhutatipamula Год назад

    Sir, pls explain power Bi program

  • @sksiva8740
    @sksiva8740 2 года назад

    Pay scale grade medha oka video cheygalaru.....
    A B C D
    A▶️15000-100-16000-110-17100
    B▶️20000-125-21250-+135-22600
    Ela unaa basic medha grade prakaram apply cheyali.......
    Govt jobs pay band scale and grades....

  • @kawalipradeeppradeep3540
    @kawalipradeeppradeep3540 2 года назад

    Hello Sir office work lo vlookup formula Ela undi ante oka column cell lo heading petti akkada vlookup formula chesi another sheet lo unna data chala ekkuva data undi aa table array motham okate sari select kaavatledu sheet lo ki ravadaaniki. Ela select cheyali chepandi.

  • @praveenkooram822
    @praveenkooram822 2 года назад

    Thank you

  • @srikanthkasala7850
    @srikanthkasala7850 4 года назад

    sir, i request you very fruitfully, plz do one or two example with
    vlookup+match from sheet1 - sheet2 find out result. if you can am very full
    fill my doubt and clear. Emp ID, Name, Dept.Name, No of present, no of absent , Salary amount, Advance Salary...
    out put: Lookup value : Emp ID, Result required : Dept.Name, Salary amount, Advance Salary with vlookup+match formula

  • @ATR007GAMING
    @ATR007GAMING 3 года назад

    Anna vlookup vaadi master sheet lo vunna data pakkana mana refference sheet avasaramina vatine thisukovalnte okasari chepandi leda video cheyandi.

  • @Prasanthreddyvlogs
    @Prasanthreddyvlogs 3 года назад +1

    Emp no same unte next ela filter cheyalee sirr

  • @sutharisindhureddy4877
    @sutharisindhureddy4877 Год назад

    Employees code sequence ga lekapothe ascending lo vunte ela brother please explain

  • @siripurapusamyuktha4340
    @siripurapusamyuktha4340 3 года назад

    Good informative...also for making header dynamic we can use match function instead of giving each time number for various headers

  • @Jai-yi2nl
    @Jai-yi2nl 3 года назад

    Meeru supppprb sir 🙏🏼

  • @multimeena941
    @multimeena941 3 года назад +1

    Make more videos on vlookup 🙏

  • @lalitmarodiya
    @lalitmarodiya Год назад

    Thanks

  • @webschoolacademy5414
    @webschoolacademy5414 3 года назад +1

    Should the particulars of Vlookup table and finding data table be with same column position?

  • @somanathbisalo8161
    @somanathbisalo8161 Год назад

    Sir please tell me what is pgdca course

  • @haikomaram
    @haikomaram 4 года назад +2

    Ok Thanks for good teaching Sir...But
    Small doubt yearly wise data How to display using vlookup formula...
    Example: 2019-20 (Available classes 4rth,5th classes )....
    Select 2019-20 & Select class 4rth now display 4rth class pupils data ,Same way Select 2019-20 & 5th class display 5th class pupils details... Available any possible Sir like above video concept...

  • @eliyavesapogu2420
    @eliyavesapogu2420 2 года назад

    Good job anna 🙏

  • @vasudrj799
    @vasudrj799 Год назад

    Well sir

  • @webschoolacademy5414
    @webschoolacademy5414 3 года назад +1

    Can we use this formula for google sheets also?

  • @saisrinivas5930
    @saisrinivas5930 2 года назад

    Sir can u teach me complete Excel , if yes how many days it will take , What will be the fee

  • @katherapakamadhu5910
    @katherapakamadhu5910 3 года назад

    Tq sir...good videos

  • @bhagyalaxmikallula6661
    @bhagyalaxmikallula6661 2 года назад

    Huge data unnapudu, veroka sheet lo konni emp id lu unnapudu, vlookup function use chestu, remaining details ni find out cheyyali... meru ee vedio lo names define chesaru kada,ala ravadam ledhu sir...

  • @1988naresh
    @1988naresh 4 года назад

    Hi bro can u please make 1 video how to change the existingdata range for name manager or tables please sugges

  • @ramaraokamtan7661
    @ramaraokamtan7661 Год назад

    How to transfer the data from cash book to ledger in excel sheet

  • @vs82173
    @vs82173 3 года назад

    Tq sir

  • @Videoskavalanayana
    @Videoskavalanayana 2 года назад

    SIR Upload Python Videos ALSO

  • @pavankrishna163
    @pavankrishna163 3 года назад

    Good

  • @koritalababu7165
    @koritalababu7165 2 года назад

    Sir everything is fine but the lookup value is not a number then how can we use if function here? Kindly answer me

  • @anjaneyulukodam9961
    @anjaneyulukodam9961 3 года назад

    Good night sir,

  • @danji6031
    @danji6031 3 года назад

    super sir

  • @nallaraputeja1459
    @nallaraputeja1459 3 года назад

    Sir total values Ni Ela chayali sir please explain chayandi sir

  • @diwakarreddy9249
    @diwakarreddy9249 3 года назад

    Thanks sir

  • @ashokpandem1996
    @ashokpandem1996 Год назад

    Hi sir can you please do sap mm videos

  • @chaitanyareddymedapati6361
    @chaitanyareddymedapati6361 3 года назад

    Excel sheet lo tabul multify aka cheyali anna

  • @potharajuramesh3005
    @potharajuramesh3005 3 года назад

    Super excited

  • @sai-vo3wk
    @sai-vo3wk 4 года назад

    If duplicate rows will it work

  • @gajulabalijarupesh5490
    @gajulabalijarupesh5490 4 года назад

    Thank you annaya

  • @haribabu-pk9wy
    @haribabu-pk9wy 3 года назад

    GOOD , PLEASE TELL HOW TO LINK DATA IN ONE EXCEL SHEET LINK TO ANOTHER SHEET WHILE PREPARING REPORT CARD OF STUDENTS

  • @sureshkrishna7762
    @sureshkrishna7762 4 года назад

    🙏thanku sami

  • @ruthv5816
    @ruthv5816 3 года назад

    Durga prasad garu I press f4 but it can't freezed. can you pls help me?😔what will I do for that.

  • @simhachalamyegoti8990
    @simhachalamyegoti8990 4 года назад

    Sir namaste please make video for combine multiple excel sheets into one sheet

  • @anilkodimala9883
    @anilkodimala9883 Год назад

    3 tables కి. ఈ formula work avvuddha ??
    *=Vlookup(A3,IF(A3

  • @surekham8944
    @surekham8944 4 года назад

    Sir multiple sheets nunchi check chestunnappduu last lo true false ani mention cheyyakkarleda?

  • @dhanushaappikonda6469
    @dhanushaappikonda6469 3 года назад

    Sir id alphabet cum numerical unty ela work cheyali

  • @nagaraju-yz1qb
    @nagaraju-yz1qb 4 года назад

    Thank you sir

  • @veereshy.t31
    @veereshy.t31 7 месяцев назад

    Anna Hlookup link unte naku pettu anna 😊

  • @shaikashraf7912
    @shaikashraf7912 4 года назад

    Adobe premiere pro apudu start chestaru sir ??

  • @syamvemuri1071
    @syamvemuri1071 3 года назад +1

    🤚👍

  • @kalivarapuravi306
    @kalivarapuravi306 3 года назад

    Exel lo salary sheet next sheet lo pay slip తయారు చేయటం ఎలా నేర్పా గలారు

  • @sainirmalaatmakuri2877
    @sainirmalaatmakuri2877 3 года назад

    One sheet lo data two or three same entryes how to find double triple entry s

  • @cdponcs8665
    @cdponcs8665 2 года назад

    BROTHER EXCEL DATA BRANCH WISE & CAST WISE QUALIFIED STUDENT COUNT FORMULA PLEASE

  • @prahshanth
    @prahshanth 3 года назад

    Dear, A3 varaku maatrame cheppparu, okavela A4 lo alaage A5,6,7 kavalante elaga, drag cheste formula apply kavatam ledu

  • @vamshikrishnaboddula37
    @vamshikrishnaboddula37 4 года назад

    Can we save vlookup formula data permanently. If yes make comment n how 😊

  • @jesusoneshim6567
    @jesusoneshim6567 3 года назад

    Bro letters type chesetappudu space echinappudu first word ni captil lo 2nd word s small letters type cheyalantay ebbandi ga undi total ni select chesi yedo chestaruga adi konchem cheppandhi

  • @saiganapathipolytechnic323
    @saiganapathipolytechnic323 4 года назад

    nenu practice cheste vamchimdhi ... but employe no. lo number tho alphabet letters iste work avvadam ledu.. ex: emp no. 101cse , 201eee, like that... so how to work ???

  • @dharanishchandavolu1696
    @dharanishchandavolu1696 3 года назад

    If employee id is a character

  • @rajkrk4238
    @rajkrk4238 2 года назад

    Giving column number manually is not advisable

  • @madhumadhuri6612
    @madhumadhuri6612 2 года назад

    Sheet name define chesanu. But formula echetappudu drop down lo nenu define chesina name kanipinchandam ledhu

  • @sathyarajvanam8763
    @sathyarajvanam8763 4 года назад

    How to add multiple excel sheets in one excel sheet..... please do one vedio

    • @Computersadda
      @Computersadda  4 года назад

      Already chesanu channel lo Chundandi

  • @kalyanisivaraju949
    @kalyanisivaraju949 4 года назад

    Department wise display kavalante mottam data

  • @maheshkatta2430
    @maheshkatta2430 4 года назад

    Daybook cheyandi

  • @kingravisunny106
    @kingravisunny106 4 года назад +1

    Sir A3 freeze avtledhu.F4 kottina avtledhu.

  • @thayurukiran5075
    @thayurukiran5075 4 месяца назад

    Anna Naku konni douts undi anna

  • @buddhasridhar4691
    @buddhasridhar4691 3 года назад

    volume very low .plz increase the sound

  • @460nishitha4
    @460nishitha4 2 месяца назад

    Link yee ledhu bro

  • @harikumarchinta9683
    @harikumarchinta9683 4 года назад

    Sir more than 3 sheets unnappudu formula ela veyaali sir