9 Ways to use " VLOOKUP " in Ms-Excel Telugu || VLOOKUP Tricks in Excel Telugu || Computersadda.com

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ก.ย. 2024
  • హాయ్ .. వ్యూయర్స్ ..
    ఈ TH-cam Channelలో Videos వలన మీకు Use వుంటే, Valuable Content అయితే, మీకు Time & Money Save అయితేనే ఈ Channel లో Members Ship తీసుకోండి. Additional Benefits పొందండి . ఈ Channel ని Support చేయండి. Members Ship కావాలి అంటే Subscribe Button పక్కనే వున్న JOIN Button ని Click చేయండి. Information చూసుకోండి.
    Click here Below Link & JOIN:-
    ========================
    / @computersadda
    ===========================================================
    Practice File Link : www.computersad...
    ======================================
    Each Course Topic wise Play list Links :-
    ================================
    Ms-Word 👉 • MS-Word 2016 Telugu Tu...
    Ms-Excel 👉 • Ms-Excel Starting Tuto...
    Ms-PPT 👉 • Ms-Power Point 2016
    Photoshop CC 👉 • Photoshop CC Telugu Tu...
    PageMaker 👉 • Pagemaker
    CorelDraw 👉 • CorelDRAW Telugu Tutor...
    Indesign 👉 • Adobe InDesign Telugu ...
    AutoCAD 👉 • AutoCAD 2D Telugu Tuto...
    Html 👉 • HTML Telugu Tutorials
    ============================================
    Facebook fan page
    -------------------------------
    / computersadda-19588509...
    TH-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 ?

ความคิดเห็น • 592

  • @Computersadda
    @Computersadda  3 ปีที่แล้ว +55

    www.computersadda.com/2020/03/x-lookup-function-in-ms-excel-practice-file/

    • @balireddyarun
      @balireddyarun 2 ปีที่แล้ว +1

      Brother Iam using apple Mac, how to replace number with words

    • @harishalibilli8448
      @harishalibilli8448 ปีที่แล้ว

      Anna anni capital lo ravali antey short cut anti

    • @harishalibilli8448
      @harishalibilli8448 ปีที่แล้ว

      Anna anni capital letters ravali antey short cut anti

    • @anilkumarchalla9032
      @anilkumarchalla9032 ปีที่แล้ว +1

      hello anna
      vlookup with if condition cheyyocha??
      eg.
      naadaggara oka sheet lo EMP IDs (COL 1), konni dates (COL 2), konni values (COL 3) unnai.
      inko sheet lo same EMP IDs (COL 1) (konni EMP IDs extra ga unnai), Konni dates (COL 2) unnai.
      ippudu naaku, vlookup chesthe, 1st sheet lo unna values, 2nd sheet lo unna EMP ID and dates tho match aayye laga data(2nd sheet lo COL3 lo) vlookup avvali.
      Google lo chala try chesa. naaku dorakaledu.
      meeru chepthe , naalanti vallaki helpful ga untundi

    • @earningwithkarthik1577
      @earningwithkarthik1577 ปีที่แล้ว

      hi

  • @prashantha5725
    @prashantha5725 3 ปีที่แล้ว +239

    Bro..Awesome bro..office lo ilanti thalanoppulu chala vasthunnayi.inni rojulu me channel naku endhuku theliyaledhu ani feel avuthunna..I subscribed..

    • @arjunb8667
      @arjunb8667 2 ปีที่แล้ว +3

      Hi bro

    • @arjunb8667
      @arjunb8667 2 ปีที่แล้ว +3

      Do you work any office

    • @prashantha5725
      @prashantha5725 2 ปีที่แล้ว +2

      @@arjunb8667 Yes.

    • @suryachowdary6097
      @suryachowdary6097 2 ปีที่แล้ว +2

      Mis executive job bhaguntundha bro growth untundha

    • @kondajogulaobulesu523
      @kondajogulaobulesu523 2 ปีที่แล้ว +3

      It's a Miracle Option in MS Excel , Thanks Brother for give us most valuable option

  • @saiarigela4887
    @saiarigela4887 9 หลายเดือนก่อน +10

    Saaarrrrrrrrrrrrrrrrr.....meeru nijamgane devudu saaaarrrrrrrrr......entha clear ga neat ga explain chesaru......hats off to you saaaaarrrrrr.......

  • @mravi5019
    @mravi5019 3 ปีที่แล้ว +19

    సార్, చాలా మంచి నాలెడ్జి ఇస్తున్నారు..మీకు ధన్యవాదాలు

  • @suryakiran6717
    @suryakiran6717 2 ปีที่แล้ว +9

    Anna, meru devudu anna..Ekada chosina ardham kaaka me videos ki vacha..Clear and clean ichi padesaru concepts thanks anna

    • @gphaniram
      @gphaniram 4 หลายเดือนก่อน

      Nijangaane, meeru devudandi.

  • @saikrishnachiru
    @saikrishnachiru ปีที่แล้ว +4

    Super explanation. Intha easy ga explanation intha varaku chudaledu nenu. Thank you so much. Mee channel lone nenu Tally nerchuko dani meede Accountant job kottaanu 2021 lo.

  • @kranthikumarkumar.426krant8
    @kranthikumarkumar.426krant8 ปีที่แล้ว +2

    Nice explanation…..oka chinna question excel lo manam verey sheet lo vunna data ni compare chesthu inko sheet loni update cheyali…alagey andhulo manaki nachina daggara… rows insert chesi data update cheyali.

  • @ThrinathFika
    @ThrinathFika 3 วันที่ผ่านมา

    Thanks Bro.. This Video helped in the office work, saved the time.

  • @ShivaKumar-yt1oj
    @ShivaKumar-yt1oj 5 หลายเดือนก่อน +2

    I'm watching this in 2024, very Helpful, thank you Durga Prasad garu.🙏

  • @massganesh
    @massganesh 2 ปีที่แล้ว +3

    Wonderful bro.... Course ki dabbulu tagileyyakunda mi videos chuste saripothadhi anna

  • @venumadhavishanmuk5179
    @venumadhavishanmuk5179 2 ปีที่แล้ว +2

    Hi sir, Me teaching chala bagundhi....Manchi Knowledge andhisthunnaru...Thank you so much for that..

  • @ramasubrahmanyam1499
    @ramasubrahmanyam1499 3 หลายเดือนก่อน +1

    Excellent. Very grateful for your detailed explanation. Thank you sir for your extended support to the learners. First time i got the clear idea on VLOOKUP.

  • @bangikrishna51
    @bangikrishna51 ปีที่แล้ว +1

    Super bro viti valla chala headech vachedhi naku meru simple ga clear ga explain chesaru👍👍👌👌👌💯

  • @jogusujith2055
    @jogusujith2055 ปีที่แล้ว +1

    Spr brother nenu excel ante bayapadevadini me vedios choosaka full confidence vachindhi

  • @dhanalakshmiveluri7746
    @dhanalakshmiveluri7746 ปีที่แล้ว +2

    Super explanation bro nenu chala nerchukuntunnanu tq so much

  • @keshavachandu99
    @keshavachandu99 2 ปีที่แล้ว +2

    Hi Miru .. hero&Comedian Sunil la ga Unnaru.. Mi classes Bagunnae..

  • @SuvarrnaM
    @SuvarrnaM ปีที่แล้ว +3

    Excellent, way of explain easily understand Thanks

  • @trinitymodelprimaryschool8794
    @trinitymodelprimaryschool8794 3 ปีที่แล้ว +2

    చాలా అద్భుతంగా ఉంది సార్. ఇంకా ఇలాంటి మరెన్నో చేయాలి సార్.

  • @mohanreddy6367
    @mohanreddy6367 ปีที่แล้ว +1

    Really chala baga explain chesaru bro Thank you

  • @bandiadisheshulu1095
    @bandiadisheshulu1095 2 ปีที่แล้ว +1

    Its super ...mi explanation bagundi thank you anna

  • @rajupmp9382
    @rajupmp9382 3 ปีที่แล้ว +3

    Super sir ... teaching exaplnation super sir ...we understanding clearly for your teaching

  • @Suresh-i4i
    @Suresh-i4i 2 ปีที่แล้ว +1

    Thanks a lot bro, chana help full avtundi maku .

  • @friendlysanthoshh
    @friendlysanthoshh 6 หลายเดือนก่อน +1

    Simple gha artham ayiyha tathlu bagha chaparu bro thanks:)

  • @haripriyag1141
    @haripriyag1141 3 ปีที่แล้ว +6

    Very clearly explained. Easy to understand. Thanq

  • @mancharlasvibes6807
    @mancharlasvibes6807 3 ปีที่แล้ว +4

    Meeru cheppedhey ..... content anna...thank you for helping students and employers

  • @madanumanasa
    @madanumanasa ปีที่แล้ว +1

    Thank you sir for providing and explaining each and every thing in easier manner

  • @satishkaranam1064
    @satishkaranam1064 2 ปีที่แล้ว +4

    thank you for good explaination as well as practise sheets

  • @DRKAllinone
    @DRKAllinone ปีที่แล้ว +1

    chaala kastapadi ardham ayyela chebuthunnav anna super

  • @vamsinaga143
    @vamsinaga143 4 หลายเดือนก่อน +1

    Thank u so much Anna
    U r expelation 👏🏻👏🏻👏🏻👏🏻

  • @krishnachaitanya9865
    @krishnachaitanya9865 2 ปีที่แล้ว +1

    Love you bhayya .. you just nailed the explanation .. Awesome

  • @manumanoj6875
    @manumanoj6875 3 ปีที่แล้ว +2

    Your are the master in MS Excel . thank you sir

  • @Rajithay4444-ot7oc
    @Rajithay4444-ot7oc ปีที่แล้ว +1

    Nice andi, good vedio, very well explaination

  • @HighRichvision2025
    @HighRichvision2025 ปีที่แล้ว +1

    Awesome explanation prasad garu,it helps lot a beginner also

  • @srinivasryali2451
    @srinivasryali2451 2 ปีที่แล้ว

    Very Useful Vedio with free of cost, otherwise we have to shell down thousands of rupees if we go to any other institutions to learn

  • @sridevik5448
    @sridevik5448 3 ปีที่แล้ว +3

    Thanks sir for giving VLOOKUP uses

  • @srikanthch5638
    @srikanthch5638 ปีที่แล้ว +4

    Your explanation is wonderful Mr Prasad.. God bless ..i wish you more success.. I have seen your channel with Just 1k and now it has gone long way with your efforts....Good luck.

  • @prasannakumar4496
    @prasannakumar4496 ปีที่แล้ว +1

    Excellent rambabu garu...

  • @deviprasadp8703
    @deviprasadp8703 3 ปีที่แล้ว +4

    Brother the way of your teaching is very impressive and please try to make videos on VBA

  • @UrsSanto
    @UrsSanto ปีที่แล้ว +2

    What a informatic video sir, you are awesome tutor 👨‍🏫... Every one should watch your videos 🎥

  • @chalmedaanandaraohospital3154
    @chalmedaanandaraohospital3154 ปีที่แล้ว +1

    SIR REALLY U R VERY GOOD INFORMATION THANKQ🙏

  • @SahithiNaidu-l5b
    @SahithiNaidu-l5b 19 วันที่ผ่านมา

    Miru great sir mi teaching ❤❤❤

  • @shankerrao8269
    @shankerrao8269 ปีที่แล้ว +1

    Super class, with very interesting videos, and detailed explanations. Thank you, sir

  • @rajugoud1563
    @rajugoud1563 2 ปีที่แล้ว +2

    Good explanation and 💯 % content is there sir.

  • @ShivaKumar-gc6so
    @ShivaKumar-gc6so ปีที่แล้ว +10

    Hello Sir, very useful video. Can you please also provide formula to check number of characters or digits in a cell.

  • @ammuamala2634
    @ammuamala2634 ปีที่แล้ว +1

    TQ 😇 So much Sir 🙏 ,U R Video's Too good 👌

  • @KUMARRAJGOPAL
    @KUMARRAJGOPAL 3 ปีที่แล้ว +1

    thanks very very very nice , what i need knowledge r date learn from your class.

  • @abdulfarooq9680
    @abdulfarooq9680 ปีที่แล้ว +1

    What a explanation sir, really super.

  • @T.V.VARDRAVARDRA
    @T.V.VARDRAVARDRA 7 หลายเดือนก่อน +2

    enta dabbu pettina inta qulity ga ekkada chepparu tq bro.

  • @modiboinadinesh6240
    @modiboinadinesh6240 2 ปีที่แล้ว

    Bro ur vedio usefull to no of people thank for the this type of vedio uploding TH-cam

  • @SrinivasReddy-ub3fb
    @SrinivasReddy-ub3fb 8 หลายเดือนก่อน

    Very helpful information thank you so much for giving valuable information.

  • @PavanKumar-xp8gl
    @PavanKumar-xp8gl 8 หลายเดือนก่อน

    Excellent 👍 class sir
    Thank you so much for this video 🙏

  • @aarthishaganti6908
    @aarthishaganti6908 10 หลายเดือนก่อน

    Thank you Sir, You are Explanation very Good Sir

  • @KC-ym5nv
    @KC-ym5nv 2 ปีที่แล้ว +5

    Hi, I am learning MS Excel now, which exam i need to take firstly on excel to get certificate from microsoft since there are multiple excel courses with same code, could you please suggest me which exam(2013/2016/2019) I need to take firstly on excel since I am a beginner

  • @shivar1498
    @shivar1498 2 หลายเดือนก่อน

    Thank you so much gurujiii very helpful to all

  • @autaanithamahesh3014
    @autaanithamahesh3014 ปีที่แล้ว

    its really really amazing super knowledge delivering to us sir tq tq allooottttt

  • @saijayaramnaidu8264
    @saijayaramnaidu8264 3 ปีที่แล้ว +2

    VERY USEFUL SIR PLEASE DO VIDEO ON X LOOK UP

  • @sriharshagade111
    @sriharshagade111 ปีที่แล้ว

    oka mnc lo final round ki videos chusi prepare avtunna. Thankyou annaya

  • @praveengovindappa6218
    @praveengovindappa6218 ปีที่แล้ว

    hello prasad,
    this vedio will very usefull for everyone
    thank you

  • @RAMACHANDRA63
    @RAMACHANDRA63 3 ปีที่แล้ว +1

    Excellent 👌👌👌👌
    Thank you so much 🥰 Really 🤩

  • @phanindrakumarvavilala804
    @phanindrakumarvavilala804 ปีที่แล้ว

    vlookup array and text superb bro! chinna doubt bro.. konchem * symbol uses ekkadekkada vadacho cheppara

  • @p.deepak449
    @p.deepak449 ปีที่แล้ว +1

    Bro sheet 1 lo unna particular rows matrame automatic ga sheet 2 copy avali ela????

  • @dhanalakshmi3355
    @dhanalakshmi3355 5 หลายเดือนก่อน

    Super explanation thanks you so much brother

  • @varaprasadkvs9180
    @varaprasadkvs9180 2 ปีที่แล้ว

    Meeru super Rambabu garu, please do video on Google calender usage and feature.

  • @tulasitellakula7941
    @tulasitellakula7941 2 ปีที่แล้ว

    Excellent sir me teaching. Thank u sir

  • @gayathrikopparthy8024
    @gayathrikopparthy8024 3 หลายเดือนก่อน

    Thanks you much naku chala use iyndi me vedio

  • @vbsstudytricks6111
    @vbsstudytricks6111 3 ปีที่แล้ว

    Bro app ela create cheyalo oka vedio cheyandi bro mi vedios chala usefull ga vunnai. Buying and selling app

  • @hemalatha-zl5sb
    @hemalatha-zl5sb ปีที่แล้ว

    Very helpful bro thank you so much explanation awesome ❤👍

  • @kishorekoritala1693
    @kishorekoritala1693 3 ปีที่แล้ว +7

    What an awesome explanation bro👏👏👏👏
    Really useful one your have shared.. thank you 🙏 so much bro…

  • @santhoshinsights_telugu
    @santhoshinsights_telugu 2 หลายเดือนก่อน

    excellent explanation ❤

  • @thatsjagadish9620
    @thatsjagadish9620 3 หลายเดือนก่อน

    super sir, simple ga bhaga chepparu

  • @yogimakkena40
    @yogimakkena40 ปีที่แล้ว

    Good explain bro content undi bro

  • @mylifemelodies2110
    @mylifemelodies2110 2 หลายเดือนก่อน

    Sir, thank you thank you so much 🙏🙏🙏..

  • @c2rju
    @c2rju 2 ปีที่แล้ว +4

    Hi.. the way of you explaining is very good. can you explain compare the percentage (%) last year to present year Prices diff

    • @vishnuvardhansingh7124
      @vishnuvardhansingh7124 ปีที่แล้ว

      Final value - initial value. Divide by final value multiply by 100

  • @sarmavedula6339
    @sarmavedula6339 2 ปีที่แล้ว +1

    చాలా బాగా చెప్పారు 🙏🙏 thank you

  • @rupaadireddy7708
    @rupaadireddy7708 2 ปีที่แล้ว

    Ms ppt kuda videos cheyandi ...baga explain chestunaru

  • @VJTrendzz
    @VJTrendzz ปีที่แล้ว

    Thank you you are my guru for excel

  • @lakshmi4041
    @lakshmi4041 11 หลายเดือนก่อน

    Bro stock list ( purchases & sales) excel lo yela maintain cheyyalo oka video cheyandi bro...ante oka item multiple dates lo sale &purchase avthundi kada adi yela calculate cheyyalo clarity ga cheppandi bro ..pl..Naa job ki help avthundi...naaku stock list yela maintain cheyyalo teliyadam ledu

  • @VickyRajMaddala
    @VickyRajMaddala 2 ปีที่แล้ว

    Thank You Sir, It helped me alot.

  • @m.v.sateesh4535
    @m.v.sateesh4535 2 ปีที่แล้ว +1

    Hi sir, i have used 4 files and applied vlookup formula to master file, vlookup chesina tarwata master file lo vunna data ni new excel file lo vlookup formulas lekunda data ni copy cheyocha..

  • @nagaraju403
    @nagaraju403 5 หลายเดือนก่อน

    Hello sir,
    Super explanation on Excel 🎉

  • @saleemuddin9860
    @saleemuddin9860 ปีที่แล้ว +1

    Thank you so much brother

  • @ashwathkamasani8351
    @ashwathkamasani8351 4 หลายเดือนก่อน

    Super....Ap Excel king bro meru🎉

  • @rajeshvemula5791
    @rajeshvemula5791 7 หลายเดือนก่อน

    Sir…..🙏🙏 overtime ni individual BP+GP+HRA tho ela calculate cheyali and late amount ni ela subs-traction cheyali with Biometric Attendance sir.

  • @jagadeeshgoli3350
    @jagadeeshgoli3350 11 หลายเดือนก่อน

    Kudos, mind blowing explanation

  • @HUNR67
    @HUNR67 7 หลายเดือนก่อน

    Hi Anna. Your videos awesome

  • @mahammadrafivalluru1602
    @mahammadrafivalluru1602 ปีที่แล้ว

    Super Brother.Your video helped me a lot .

  • @kumar-hc8ju
    @kumar-hc8ju 3 หลายเดือนก่อน

    good teaching sir

  • @RajKumar-rl3lz
    @RajKumar-rl3lz 2 ปีที่แล้ว

    Hello bro, miru chaala clear ga explain chesthunnaaru.. Thank u for sharing ur knowledge. And I need one help, ippudu oka sheet lo 10 records unnai and next inko sheet lo same 10 records unnai but order different lo undhi.. Akkada 1st record ikkada 5th row lo undochu... So ippudu ee 2nd sheet lo records ni same first laaga arrange cheyyaali... Please suggest

    • @apchambers445
      @apchambers445 2 ปีที่แล้ว

      No avasaram ledu , you can use vlookup formula directly

  • @sarathk9774
    @sarathk9774 2 ปีที่แล้ว

    Excellent Viedo Bro
    Nice video , very useful for me

  • @swathigovada1637
    @swathigovada1637 ปีที่แล้ว

    Excellent explanation sir....thankyou

  • @farukbasha5666
    @farukbasha5666 ปีที่แล้ว +1

    Brotheruuuu meru thopu antee 🔥🔥🔥🔥🔥 Prasad sir is not a name it's a brand 😍😍😍

  • @simplevideos8648
    @simplevideos8648 ปีที่แล้ว +1

    Bro, Errors Vachhinappudu ela rectify cheyyalo video cheyyandi,
    ****With out any errors meeru chepparu , So if errors came (N/A) yela cheyyali ****

  • @venkat6406
    @venkat6406 3 ปีที่แล้ว +1

    Thank you sir keep doing more videos on exel and Photoshop

  • @jyothsnap6047
    @jyothsnap6047 2 หลายเดือนก่อน

    Excellent sir.. Array formula useful

  • @swathirongali1500
    @swathirongali1500 11 หลายเดือนก่อน +2

    F4 press chesthuntey freeze avvadam ledhu 🤔

  • @venkatasaigurakaa1154
    @venkatasaigurakaa1154 ปีที่แล้ว

    I like this very much , very helpful bro thanks you so much it's a full of contant i am one of your subscription thank you 🥰

  • @OpBlack-e9w
    @OpBlack-e9w หลายเดือนก่อน

    Tq sir so helping this video

  • @raviteja1324
    @raviteja1324 9 หลายเดือนก่อน

    Anna nenu bank lo Pani chesta miru vlookup chala neat cheptunaru ....

  • @RaviKumarThamminana
    @RaviKumarThamminana ปีที่แล้ว

    Tammu, baundi e video.. and last example, (V lookup lo first name tho wild character character * ni use chesi explain chaesaav, baundi and oka vela iddariki or mugguraki first name same ga untey? then vts ur advise?

  • @sundarambati7044
    @sundarambati7044 2 ปีที่แล้ว

    Super anna..
    Thank you for valuable information