Excel VLOOKUP Function with Example in Telugu || www.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 చూసుకోండి.
    =================================================================
    XLOOKUP Video Link below:
    ==================================================
    • ADD & USE XLOOKUP Func...
    ==================================================
    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...
    ---------------------------------------------------------------
    30 Excel Formulas with in 1/2 hour
    --------------------------------------------------------------
    • 30 Above Ms-Excel Form...
    -----------------------------------------------------------------------
    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 ?

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

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

    సార్.
    మీ పాఠాలు చాలా బాగున్నాయి...మీకు మా ధన్యవాదములు 🙏

  • @mohd.siddiqabbu9529
    @mohd.siddiqabbu9529 6 ปีที่แล้ว +3

    Sir.
    You have explained very perfect way. ...I got it ..I m
    A new one...
    Thank you

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

    Superb explanation......SAP ki kudaa oka video cheyyandi

  • @esware5863
    @esware5863 6 ปีที่แล้ว +9

    Explained well. Thank you brother. keep-it up.

  • @SCshekar4946
    @SCshekar4946 6 ปีที่แล้ว +5

    Thanku brother Chala baga అర్థమవుతుంది

    • @sathishkarampuri807
      @sathishkarampuri807 5 ปีที่แล้ว

      Excel tutorial th-cam.com/video/oBetQqMj0nU/w-d-xo.html please subscribe my channel

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

    nice explanation sir, your vedios always useful, thanks sir.

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

    Thank you very much it saved me a lot of work today...I learnt it and used it today in my office work sir

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

    Reallyy Chala help ayyindi , I'm very interesting to learn... Thank u

  • @actoramana6720
    @actoramana6720 5 หลายเดือนก่อน +3

    అసలు చిన్నప్పుడే మీదగ్గర నేర్చుకుంటే , ఈ పాటికి మైక్రోసాఫ్ట్ CEO అయ్యేవాణ్ణి 😁

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

    thanks for your explanation

  • @rajus.a3881
    @rajus.a3881 5 ปีที่แล้ว +2

    Good sir chala simple ga understand ayetu cheyparu, keep it up sir, I hope in future u will tell more useful subject.
    Thank you sir

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

    Thanks very much boss, very useful information sharing and teaching to all .relay very very very......! use full

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

    Heartful to Thank you so much bayya,meku Anni thanks lu cheppina saripovu bayya

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

    Thanks you so much sir.. good example and good explanation..

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

    Thank you sir for clean explanation

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

    Thank u bro..very useful nd cristal clear ga chepparu..keep it up👍

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

    Super explanation
    Very good information 👍👌👌 bro

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

    Sir,
    mee valla EXCEL knowledge full ga nerchukunnam
    thank u
    SAP gurinchi kuda okka video cheyandi

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

    Chaala bagundhi explination

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

    Your explaining anything clearly, super brother

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

    Good Video. Easy to understand. Thank you

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

    Sir excellent explanation...thank you for explaining in telugu....can you please share video on vlookup for multiple sheets

  • @chandrasekhar-lp8py
    @chandrasekhar-lp8py 6 ปีที่แล้ว +34

    Sir Vlookup lo sheet 1 data ni sheet 2 data tho match cheyadam Elano cheppandi .....

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

    Best example with best explanation. Thank you sir. Sir other sheet lo unna data ravalante em cheyyali sir

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

    Your teaching very good

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

    Excellent sir simple explanation

  • @lakshmanmudiraj4890
    @lakshmanmudiraj4890 5 ปีที่แล้ว +8

    Hello sir your explanation is good but #N/A Ani vastumdi kadha alarakudadhu ante IF ERROR use cheyandi sir example =iferror(vlookup(data,data:data,data,0),"") Ani use cheyamdi #N/A radhu

    • @MrYeduguri
      @MrYeduguri 5 ปีที่แล้ว

      Super brother.. 👍👍

    • @magicexcel7166
      @magicexcel7166 4 ปีที่แล้ว

      Yes, if you get error in any formula.

  • @actoramana6720
    @actoramana6720 5 หลายเดือนก่อน +1

    Superb explanation👏👏👏

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

    Usefull video sir thank you

  • @sureshbommakanti4259
    @sureshbommakanti4259 4 ปีที่แล้ว

    Excellent bro thank you very much...

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

      Thank u share the videos 😊

  • @anjaneyulukodam9961
    @anjaneyulukodam9961 6 ปีที่แล้ว

    Good morning sir,
    Fine teaching i liked very much.

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

    Thank you so much sir , you explain very easily...

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

    Chaala baaga explain chesaru sir👍

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

    Very useful information

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

    Don't understand your language but it's a good idea VLOOKUP formula.

  • @manipalukuru2476
    @manipalukuru2476 4 ปีที่แล้ว

    Thank you so much, now I'm cleared.
    Very good explanation with many examples.

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

    Tq , super explanation bro

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

    Excellent sir super explain

  • @v.mahendramahi599
    @v.mahendramahi599 6 ปีที่แล้ว +2

    Very good explanation sir

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

    Table chala peddaga unte select cheyyadam koncham kastam kada sir

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

    Nice Explanation, thanks bro

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

    Super annayya thank you so much

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

    Really great sir. You have explained very good in our local language. It easily helps people who have difficulty in understanding class in english.

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

    brother ,salary payslip prepare cheyyadam kuda oka video cheyyandi, vere vaallavi vunnayi gani clarityga levu

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

    Good information ..... Tq

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

    Vlookup dwara school time table teacher and class wise easy ga vunde vidam ga okka video cheyandi sir

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

    Well explained sir

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

    Sir me videos chustutanu, nice videos plse clear my doubt sir, my doubt is in vlookup formula if blank cell is there it show blank cell but it showing 00-01-00 for dates

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

    good examples and good explanation

    • @sathishkarampuri807
      @sathishkarampuri807 5 ปีที่แล้ว

      Excel tutorial please visit my channel and don’t forget to subscribe th-cam.com/video/oBetQqMj0nU/w-d-xo.html

  • @prasannarao9000
    @prasannarao9000 5 ปีที่แล้ว +9

    Sir please tell me how to use v lookup Formula in different sheets... Please make a video

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

      Good question

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

      Meeku .. answer dorikinda

  • @Think-c3z
    @Think-c3z 3 ปีที่แล้ว

    Good explanation..

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

    Thank u sirrrr😘😘😘😘

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

    Very nice

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

    Teaching super sir

  • @NaveenKumar-zx4mp
    @NaveenKumar-zx4mp 3 ปีที่แล้ว

    Super boss 👍

  • @surenderchinnachinna6937
    @surenderchinnachinna6937 4 ปีที่แล้ว

    Tqusm sir for your clear explanation it is helpful to us 👍

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

    Dear sir,
    Pls solve my issue in Excel sheet
    I belonged to automobiles we have several part numbers, several bin locations.
    Part numbers will repeat but locations will change,so we use pivot table and we will get part number as single without duplicate,
    Against part number bin locations should display in one cell by using "if condition or vlookup" function.
    Pls do the needful sir
    Regards
    Radhakrishna

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

    Tq anna super ga cheppavu tq vmuch

  • @HDmoviestheatre
    @HDmoviestheatre 4 ปีที่แล้ว

    Good explaination

  • @MrRishwanth
    @MrRishwanth 6 ปีที่แล้ว

    Good explanation
    Please give a big different sheets exampls

  • @inumulapushpalatha8044
    @inumulapushpalatha8044 6 ปีที่แล้ว

    Tank u andi Chala baga aedhamaendhi tqq

  • @venkaiah_yadav
    @venkaiah_yadav 4 ปีที่แล้ว

    Thank you very much sir for your class

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

    Super broo

  • @pramod.amarlapudi
    @pramod.amarlapudi 5 ปีที่แล้ว

    Awesome job done. Gave a thumbs up!

    • @Computersadda
      @Computersadda  5 ปีที่แล้ว

      Thanq ... Share the Videos....

  • @lokeswarareddybontha4299
    @lokeswarareddybontha4299 5 ปีที่แล้ว

    Brilliant job sir, it is easy to learn

    • @Computersadda
      @Computersadda  5 ปีที่แล้ว

      thanq ............. share the videos

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

    Good work

  • @DineshKumar-bw6pz
    @DineshKumar-bw6pz ปีที่แล้ว

    Thank you sir, oka sheet lo huge data unte ela select cheyyali

  • @sarikamatmari616
    @sarikamatmari616 5 ปีที่แล้ว

    You are a genius !!!

  • @Softwarefarmer.
    @Softwarefarmer. 6 ปีที่แล้ว +2

    Hello sir please uploading video SAP FI/CO Like Tally 6 hrs Class.I am requesting to you.

  • @omprakashanapana5046
    @omprakashanapana5046 4 ปีที่แล้ว

    Good technical formals for excel learners

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

    Good Excellent ......

    • @sathishkarampuri807
      @sathishkarampuri807 5 ปีที่แล้ว

      th-cam.com/video/oBetQqMj0nU/w-d-xo.html Please subscribe my you tube channel

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

    Formula lo content mottam select chesaavu malli column anduku chusi select cheyyali.manany type chesukovachu kada sir.
    Column B adi column 2 kaadu.

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

    very good sir

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

    Sir please Gst kosam full vedios cheyandi please

  • @1991kanth
    @1991kanth 6 ปีที่แล้ว

    Superb ga cheparu bro

  • @m.mahesh2155
    @m.mahesh2155 3 ปีที่แล้ว

    Marketing job excel jobs for example cars or tractor showroom or hospital feild excel problem
    Pls tell me.. ...
    🙏🏻🙏🏻💐💐💐💐

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

    Use ayyindi bro

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

    Super sir 🌽

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

    Good explanation bro

  • @tarinippatnaik739
    @tarinippatnaik739 5 ปีที่แล้ว

    good things to learn...thanka a lot

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

    Hi Sir, I have one Doubt, We should learn only with advanced level of excel - 2016 or we can learn with also 2007,
    please reply...

    • @magicexcel7166
      @magicexcel7166 4 ปีที่แล้ว

      Kishore Kumar K if you learn MS 2016 thats enough it’s upgraded version than MS 2007

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

    Good classes

  • @subramanyamys8626
    @subramanyamys8626 4 ปีที่แล้ว

    Good class

  • @Rahul-oz7kb
    @Rahul-oz7kb 2 ปีที่แล้ว

    Thank you so much sir

  • @addepallyuday5629
    @addepallyuday5629 5 ปีที่แล้ว

    Simply super

  • @srinathaansri4164
    @srinathaansri4164 5 ปีที่แล้ว

    Super sir

  • @rajuvardhanmogadali2218
    @rajuvardhanmogadali2218 8 หลายเดือนก่อน

    Hello Sir,
    please explain how to use the functions and understand to usage

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

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

    Sir, Meru formula use chesinappudu only EMP number use chesaru.
    Okavela emp number place lo emp name use chestei formula work cheyadam ledu. Antei formula only first column ki use avtada, second column ki use cheyali antei yela

  • @SolutionDomainNvp11
    @SolutionDomainNvp11 5 ปีที่แล้ว

    Super bro. Thank you.

  • @Jyoshna-xq1lk
    @Jyoshna-xq1lk 2 ปีที่แล้ว

    Nice bro

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

    Can we search emp code by typing emp name?

  • @ssandeepkumar1295
    @ssandeepkumar1295 4 ปีที่แล้ว

    Helpfull. Thank you

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

    Hello sir.. Thx.. For excellent videos but sometimes i cant take info from previous or next sheet only possible to do in same sheet retriving data not possible to retrive from other sheets

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

    i have one doubt
    while i trying to get the vlooup for value for area name result will be displaying in numbers how can i rectify to display area name

    • @EshwarN03
      @EshwarN03 5 ปีที่แล้ว

      hope you have wrongly selected table array or index numb.. check once

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

    Sir mouse use jeyakunda tables ni select short (keyboard)use jesi select chaiyocha

  • @1988jeevan
    @1988jeevan ปีที่แล้ว

    Thank you good 🎉🎉🎉

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

    excellent 👌👌

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

    Sir my small doubt 1 mrn tack 3 items we are posted so we used in excel vlookup tacking 1st one remaining two not taking please explain sir

    • @EshwarN03
      @EshwarN03 5 ปีที่แล้ว

      apply lock symbol...$

  • @sureshkrishna7762
    @sureshkrishna7762 4 ปีที่แล้ว

    sir namasthe...na daggara list of 1000 accounts unnayi daniki related ga only one coloum lo data undi and inko Danilo 100 accounts matrame at a time lo select cheyagalana single single ga kakunda