Excel Left Vlookup or Reverse Lookup using Advanced Excel Formula | Prabas MS Office Tamil

Поділитися
Вставка
  • Опубліковано 30 жов 2024

КОМЕНТАРІ • 81

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

    The practice file is available in the following link:
    www.prabastech.in/free-downloads/

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

    Thank you for wonderful video

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

      Thanks Maeshal for voting Prabas MS Office. Happy learning.

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

    Hi Prabha.. Romba Naal achi video parthu..

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

      Hi Sadha Sivam,
      Thanks for your comment, request you to introduce our channel with your best friends.

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

      Haven't you see the message that I sent regarding the last GiveAway?

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

      @@Prabasmsoffice Sure Prabha .. Will do ..last few months I haven't seen any excel videos.. Here after I have to continue ..

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

    sir nenga vera level... nenga solradhu nalla understand agudhu bore adikkala ipdiye sollunga... Thank u so much...

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

      நன்றி. நமது channel ஐ உங்கள் நண்பர்களிடம் பகிர்ந்து கொள்ளுங்கள். கற்க கசடற.

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

      Thanks for your energetic comment. 👍

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

    Sema sir thanks for video

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

      Practice file is also provided in the usual location, utilize it if needed.
      Thanks for your comment, request you to introduce our channel with your best friends.

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

    Very Good teaching ...

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

      Hi Sameer, thanks for your comment. Keep learning and supporting.

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

    Thank you very much. Please come out with more such videos. My suggestions you can start an online class for those who want to learn excel. If you already have please let us know how to.

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

    Thanks sir, your video more use full my job

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

      Thanks for posting your comment, it boost us to post more such videos. Happy learning

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

    Interesting class 🙌

  • @Manikandan-eh1hj
    @Manikandan-eh1hj 4 роки тому +2

    Super explanation 👏👏👏👏👍

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

      Thanks for your comment, request you to introduce our channel with your best friends.

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

    Good one xlookup sample 2 is very nice, and one think iferror super

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

      Thanks for your continuous learning. Happy learning.

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

    very useful thanks sir

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

    Super explanation

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

    Useful video sir

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

    Thanks. I expect the video for XOR function

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

      Sure try to post that too.
      Thanks for your comment, request you to introduce our channel with your best friends.

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

    Nice explained...🙏

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

    Very fantastic and detailed explanation sir I learned lot of XL formula's from you thank you. Sir

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

    Super thank you sir

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

    Second one wow very nice.. formula going long. But we reached got answers. Thank you very much 😊❤️❤️

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

    Very Useful video

  • @balamurugana6018
    @balamurugana6018 2 роки тому +1

    Great sir

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

    Good explanation in Tamil.

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

    Nice presentation sir🙏

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

    Hi bro, I really loved your videos and it will be very useful for me. the way your are explaining and teaching with an example makes me to understand the concept much better. Keep doing this good work

  • @SriniVasan-kv1tf
    @SriniVasan-kv1tf 4 роки тому +1

    Super l like u

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

    Super plz update day or two day one

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

      Sure Selva,
      Thanks for your comment, request you to introduce our channel with your best friends.

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

    hi bro i really loved your videos and for same name two unique number is given. how to show in index match at a time for both?

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

      Use a Helper Column by combining your unique value with other data. Then use it in Index match formula.

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

    Thanks sir❤❤❤

  • @dm-zd5nu
    @dm-zd5nu 4 роки тому +3

    nice concept dude. While running the video u ask one question.. what is meaning of #### this error...ii want share wat i know..Genereally this display two concepts such as, that particular cell does not fit value(i.e, if the value was too large) during that time we expand particular cell we get solutions.second one is if we give wrong format like one cell contains under date format means we insert negative value or any wrong data means during that time we face this issue.. finally it is my predication i donwt know wheather this one right or wrong but i want to say what it means we lock T3 cell at the same time we drag formula to all columns t3 is fixed reference . we delted t3 cell values (emp id) so all coulms value depends in t3 cell so it reflects ### error to all coulms at same time dude am i rit?

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

      Sounds good brother...
      Thanks for responding and understanding my question....

  • @ajayselvakumar3359
    @ajayselvakumar3359 4 роки тому +4

    Ads are coming Good progress bro. Share your bank Account/No I want to give some money

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

    Super

  • @k.k.sabariraj6484
    @k.k.sabariraj6484 4 роки тому

    My output results is #N/A pls help me ( 2and big table ).. here I am correctly following ur instructions

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

    Bro iferror function it's not working for sum conditions,
    Ex:
    =Iferror (sum(range: range),"")

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

    Sir. Good. I have a doubt. The name is one more same Indra. How to do Chech from task 2

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

      If you have any second instances, you have to use the * Advanced Lookup* option, watching the following video can tech you the trick:
      ua-cam.com/video/dqgJbpcW0PA/v-deo.html

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

    I need advance macro personal training requirement

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

    Sir,
    How to create indication alarm (pass/fail) number instead of letters?
    Ex.
    abcdef - pass
    0gh3hy - fail
    Ghjjjfy - pass
    34ghy6 - fail

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

      Sir,
      In the same concept how set the indication alarm (pass/fail) letter instead of number?
      Example - 123456 - pass
      345726 - pass
      12b45a - fail
      c323h6 - fail

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

      Hello sir,
      I am awaiting for your reply

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

      My recommendations below:
      1. VLOOKUP
      2. If condition
      Let me know if my recommendations are confusing

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

      @@Prabasmsoffice sir,
      Pls send the formula to me

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

      Sir,
      I have tried if function with some formula but indication will not not come, so that pls send both (letter inseated of number & number instead of letters) indication formula to me

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

    Bro Orey Sheet la Formula Pota Work Aagaathu ! Idhu 2 Excel la Formula Pota NA Dhaan Varuthu

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

      I will make a new video for this, stay tuned.

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

      @@Prabasmsoffice Bro Intha Video La Iruka Method Oru Excel la Multiple Sheet la Intha Formula Work Aaguthu ! But Rendu Excel Work Pannumbothu Formula Podra Antha Column la Dhaan Work Aaguthu ! Formula ah Copy Panni Next Row la Pota NA Dhaan Varuthu ! So Work Aagura Maari Oru Video Podunga Please ❤️

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

      Noted

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

      @@Prabasmsoffice Tq Bro Seekram Podunga Video ! Enaku Use Aagum Bro

  • @mohamedishack.a.k7735
    @mohamedishack.a.k7735 2 роки тому

    Iferror formula

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

    iferror formula

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

    it doesnt work when i work with two sheet. :/

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

    Whole Microsoft Excel Sheet, Formulas adjustment any ideas in one Video Click.

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

      It is possible,
      We can create macros for your custom requirement.