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

Поділитися
Вставка
  • Опубліковано 9 вер 2024
  • Above Topic Excel Format File Link below :-
    ---------------------------------------------------------------------------
    www.computersad...
    ======================================
    Ms-Excel Tricks & Tips:-
    ===========================
    • 12 Ms-Excel Shortcuts ...
    --------------------
    • 10 Ms-Excel Shortcuts ...
    -------------------
    • Ms-Excel Tricks in Tel...
    ===========================
    Function Keys (F1 to F12) All Software's
    ----------------------------------------------------------------
    • Playlist
    ----------------------------
    More Computer Courses Videos Links in below
    ---------------------------------------------------------------------------
    Ms-Word in Telugu with in 5 Hours
    ------------------------------------------------------
    • Ms-Word Complete Tutor...
    -----------------------------------------------------------------------
    Ms-Power point in Telugu with in 1 1/2 hour
    ----------------------------------------------------------------
    • Ms-Power Point Complet...
    --------------------------------------------------------------
    Tally in telugu with in 6 hours
    -----------------------------------------------------------------
    • Tally Complete Tutori...
    ---------------------------------------------------------------
    PHotoshop in Telugu with in 7 Hours
    ----------------------------------------------------------------
    • Photoshop Complete Tut...
    ------------------------------------------------------
    Pagemaker in telugu with in 4 hours
    -------------------------------------------------------
    • Adobe Page Maker Compl...
    ======================
    Facebook fan page
    -------------------------------
    / computersadda-19588509...
    UA-cam Channel page
    ------------------------------------
    / @computersadda
    ------------------------------------------------------------------------------------------------------------
    Hi Friends. Welcome to our Adda.
    Complete Telugu Video Tutorials.
    Ms-office,Tally ERP 9, Accounts,Photoshop, Pagemaker, CorelDRAW, AutoCAD (2D & 3D), C Lang, Basics of Computers, Html, Tips & Tricks, Weekly QUIZ.
    All Courses Shortcuts keys, Theories,
    Abbreviations,What & Who is This ?

КОМЕНТАРІ • 124

  • @Computersadda
    @Computersadda  4 роки тому +7

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

  • @user-nj8ry9uf5k
    @user-nj8ry9uf5k 4 місяці тому

    Thanks anna Mee videos chusi nen vlookup nerchukunttumnanu

  • @Pavanisontyana
    @Pavanisontyana 9 місяців тому

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

  • @GangaS0143
    @GangaS0143 Місяць тому

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

  • @RaghoooVTech
    @RaghoooVTech 3 роки тому +2

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

  • @shyamalarajeshpolimera6363
    @shyamalarajeshpolimera6363 4 роки тому +3

    Excellent coaching

  • @karimnagarian2776
    @karimnagarian2776 Рік тому

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

  • @lakshmivasavi8432
    @lakshmivasavi8432 4 роки тому +2

    Very useful video who works in excel sheets

  • @venkatasundeep7670
    @venkatasundeep7670 3 роки тому +1

    Excellent bro.....

  • @kranthij3561
    @kranthij3561 4 роки тому

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

  • @vamsikrishna7550
    @vamsikrishna7550 3 роки тому

    Very good information video. Thanks 🙏

  • @durgamanasa1420
    @durgamanasa1420 2 роки тому

    THANKYOU FOR DOWNLOADED FILES

  • @nagarjunakomma7501
    @nagarjunakomma7501 4 роки тому +1

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

  • @kumarjJ-op7pu
    @kumarjJ-op7pu 5 місяців тому

    Excellent sir.

  • @princemjprasanth8954
    @princemjprasanth8954 3 роки тому

    Thanks for the helpful video Sir.

  • @mudemadhu9898
    @mudemadhu9898 Рік тому

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

  • @bhanumurthy100
    @bhanumurthy100 3 роки тому +1

    Super

  • @yogeshwarreddy2808
    @yogeshwarreddy2808 2 роки тому

    wow.......what an explanation

  • @mahendrakotakonda1259
    @mahendrakotakonda1259 10 місяців тому

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

  • @soujanyabommena182
    @soujanyabommena182 2 роки тому

    Excellent sir ... Tq u sir

  • @vaibesb4u
    @vaibesb4u 2 роки тому

    Very useful man

  • @rakeshkompalli904
    @rakeshkompalli904 3 роки тому

    Thanks Anna nee valla job ki chances perigayi

  • @munisaimechanical3087
    @munisaimechanical3087 4 роки тому

    Bro,
    Your explanation was damn good.

  • @praveenkooram822
    @praveenkooram822 2 роки тому

    Thank you

  • @SumatriChannel
    @SumatriChannel 2 роки тому

    thank you good explanation sir

  • @vasudrj799
    @vasudrj799 11 місяців тому

    Well sir

  • @lalitmarodiya
    @lalitmarodiya Рік тому

    Thanks

  • @akhilkumar_Official
    @akhilkumar_Official 2 роки тому

    excellent video 👌👌👌

  • @cutedevi4120
    @cutedevi4120 3 роки тому +1

    Thanks you so helpful

  • @Jai-yi2nl
    @Jai-yi2nl 3 роки тому

    Meeru supppprb sir 🙏🏼

  • @siripurapusamyuktha4340
    @siripurapusamyuktha4340 3 роки тому

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

  • @haikomaram
    @haikomaram 3 роки тому +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...

  • @pavankrishna163
    @pavankrishna163 2 роки тому

    Good

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

  • @killisimhachalam5178
    @killisimhachalam5178 2 роки тому

    Sir naku oka dout
    Direct ga Direct applychesta saripodni kadha

  • @maheshabbagoni4851
    @maheshabbagoni4851 2 роки тому

    Thank you so much sir

  • @bhagyalaxmikallula6661
    @bhagyalaxmikallula6661 Рік тому

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

  • @katherapakamadhu5910
    @katherapakamadhu5910 3 роки тому

    Tq sir...good videos

  • @eliyavesapogu2420
    @eliyavesapogu2420 2 роки тому

    Good job anna 🙏

  • @potharajuramesh3005
    @potharajuramesh3005 3 роки тому

    Super excited

  • @multimeena941
    @multimeena941 3 роки тому +1

    Make more videos on vlookup 🙏

  • @bramesh6918
    @bramesh6918 2 роки тому

    Focus gurinchi explain chayandi.

  • @webschoolacademy5414
    @webschoolacademy5414 3 роки тому +1

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

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

  • @danji6031
    @danji6031 3 роки тому

    super sir

  • @nagasrinu1552
    @nagasrinu1552 Рік тому

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

  • @mantripragadaseshu5785
    @mantripragadaseshu5785 Рік тому

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

  • @diwakarreddy9249
    @diwakarreddy9249 2 роки тому

    Thanks sir

  • @snehacreation5143
    @snehacreation5143 Рік тому

    sir meru emp no order wise vasti correct answer vasthondi kani nenu disorder lo emp number vesti answer ravatledhu😢

  • @syamvemuri1071
    @syamvemuri1071 3 роки тому +1

    🤚👍

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

  • @vs82173
    @vs82173 3 роки тому

    Tq sir

  • @anjaneyulukodam9961
    @anjaneyulukodam9961 3 роки тому

    Good night sir,

  • @gajulabalijarupesh5490
    @gajulabalijarupesh5490 4 роки тому

    Thank you annaya

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

  • @bhagyalaxmikallula6661
    @bhagyalaxmikallula6661 Рік тому

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

  • @ramakrishnabonthu1287
    @ramakrishnabonthu1287 2 роки тому

    Hlookup gurinchi full video kavalisir

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

  • @ashokpandem1996
    @ashokpandem1996 10 місяців тому

    Hi sir can you please do sap mm videos

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

  • @Madhutatipamula
    @Madhutatipamula Рік тому

    Sir, pls explain power Bi program

  • @webschoolacademy5414
    @webschoolacademy5414 3 роки тому +1

    Can we use this formula for google sheets also?

  • @nagaraju-yz1qb
    @nagaraju-yz1qb 4 роки тому

    Thank you sir

  • @sureshkrishna7762
    @sureshkrishna7762 4 роки тому

    🙏thanku sami

  • @sutharisindhureddy4877
    @sutharisindhureddy4877 Рік тому

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

  • @1988naresh
    @1988naresh 4 роки тому

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

  • @sharemarketby100mviews
    @sharemarketby100mviews 2 роки тому

    🌹👍🏻

  • @somanathbisalo8161
    @somanathbisalo8161 Рік тому

    Sir please tell me what is pgdca course

  • @ramaraokamtan7661
    @ramaraokamtan7661 Рік тому

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

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

  • @Videoskavalanayana
    @Videoskavalanayana 2 роки тому

    SIR Upload Python Videos ALSO

  • @kingravisunny106
    @kingravisunny106 3 роки тому +1

    Sir A3 freeze avtledhu.F4 kottina avtledhu.

  • @saisrinivas5930
    @saisrinivas5930 2 роки тому

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

  • @surekham8944
    @surekham8944 4 роки тому

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

  • @gurijalasandeep2293
    @gurijalasandeep2293 2 роки тому

    Waiting for c language sir.

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

  • @simhachalamyegoti8990
    @simhachalamyegoti8990 3 роки тому

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

  • @nallaraputeja1459
    @nallaraputeja1459 3 роки тому

    Sir total values Ni Ela chayali sir please explain chayandi sir

  • @madhumadhuri6612
    @madhumadhuri6612 2 роки тому

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

  • @dhanushaappikonda6469
    @dhanushaappikonda6469 3 роки тому

    Sir id alphabet cum numerical unty ela work cheyali

  • @prahshanth
    @prahshanth 3 роки тому

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

  • @sai-vo3wk
    @sai-vo3wk 4 роки тому

    If duplicate rows will it work

  • @anilkodimala9883
    @anilkodimala9883 Рік тому

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

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

  • @chaitanyareddymedapati6361
    @chaitanyareddymedapati6361 3 роки тому

    Excel sheet lo tabul multify aka cheyali anna

  • @vamshikrishnaboddula37
    @vamshikrishnaboddula37 4 роки тому

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

  • @srikanthgali8991
    @srikanthgali8991 3 роки тому +1

    HOW TO USE THE MULTIPLE VALES IN VLOOUP

  • @sainirmalaatmakuri2877
    @sainirmalaatmakuri2877 3 роки тому

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

  • @dharanishchandavolu1696
    @dharanishchandavolu1696 2 роки тому

    If employee id is a character

  • @shaikashraf7912
    @shaikashraf7912 4 роки тому

    Adobe premiere pro apudu start chestaru sir ??

  • @cdponcs8665
    @cdponcs8665 2 роки тому

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

  • @460nishitha4
    @460nishitha4 28 днів тому

    Link yee ledhu bro

  • @veereshy.t31
    @veereshy.t31 5 місяців тому

    Anna Hlookup link unte naku pettu anna 😊

  • @Kuppala1969
    @Kuppala1969 Рік тому

    if 102 is in 3 sheet then how

  • @BonthalaRamesh
    @BonthalaRamesh 4 роки тому

    Video lo sound ledu dayachesi sound koddiga penchandi next video nundi please

  • @sathyarajvanam8763
    @sathyarajvanam8763 4 роки тому

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

  • @kalyanisivaraju949
    @kalyanisivaraju949 4 роки тому

    Department wise display kavalante mottam data

  • @thayurukiran5075
    @thayurukiran5075 3 місяці тому

    Anna Naku konni douts undi anna

  • @maheshkatta2430
    @maheshkatta2430 4 роки тому

    Daybook cheyandi