What is VLOOKUP vs HLOOKUP | MS Excel Malayalam

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

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

  • @faizalabdulrahim
    @faizalabdulrahim 4 года назад +4

    Thanks Bro..Very valuable and useful video ..

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

    Njan vlookaup padikkan kure video kandu..
    Athil onnukoode manasilyath chettande video thanne...
    Thank you so much sir❤️👍

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

    📌To Learn Microsoft Excel in English, Click on the Below Link:
    ruclips.net/video/Cn3-bLDkGMY/видео.html

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

    I am using vlookup function, very useful and multi purpose in excel ever I seen function

  • @prasadrk6507
    @prasadrk6507 Год назад +4

    Nice videos. Thanks a lot, I learnt a lot from your videos.
    I have a doubt, if we have large data and when we filter the data some rows goes hidden. I tried to vlookup, but error poping up, can you please post a video on this topic.

  • @pearlsypriya
    @pearlsypriya 2 года назад +2

    Nicely demonstrated and very easy to understand. Thank you.

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

    Thanks Bro I am watching your videos one by one, its really helpful

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

    This video very usefull ,Thank u sir ❤😍

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

    Thanks brother . Good presentation.

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

      Thanks for your feedback and I'm glad it helped 😊
      You can download file used in the video : www.rowscolumns.com/free-excel-templates

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

    This video was really useful.. thank you so much ✨😇

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

    Informative video

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

    The best XL tutorial i ever seen, keep it up

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

    Its helpful for the students

  • @me.nandan2699
    @me.nandan2699 2 года назад

    Nice video bro, very much informative.

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

    Thanks bro

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

    good presentation...very helpful

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

    very helpful
    thank you dear sir

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

    Thank you sir.
    Super.
    very useful

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

    Thank you so much

  • @ElizabethMathew-m7s
    @ElizabethMathew-m7s 10 месяцев назад

    Thank you so much sir

    • @rows_columns
      @rows_columns  9 месяцев назад

      Appreciate your positive feedback! Thrilled to hear you liked the video. Keep enjoying and stay tuned for more!😊

  • @AswanthAswanth-y9k
    @AswanthAswanth-y9k 5 месяцев назад

    Very useful video ❤❤

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

    3:15 Sir 0 ഇട്ടാലും കുഴപ്പമില്ല എന്ന് പറഞ്ഞില്ലേ. Zero use ചെയ്യുന്നത് എന്തിനാണ് എന്ന് പറഞ്ഞു തരുമോ?

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

    Hai,i have a file includes employee name and code.and I have got another file with employee names only . Is it possible to vlookup with name to get employee code.Kindly help

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

    In comparison for me only two data getting displayed remaining it shows Nil may i know the reason

  • @zain-rd8fu
    @zain-rd8fu 2 года назад

    Very useful😍

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

    Great sir

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

    Thanks Alfan sir. How to set a searchable drop down list?

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

      Tnx Mate :) We can set up.. same I will upload it soon👍 In sha allah.☺️ Am planning to create full fledged video on Sales, Purchase along with p/L & Inventory.. on that I will explain it🤝

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

      @@rows_columns thanks , im waiting. How to create a form without VB?

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

      @@remo89sr I will upload the same in coming week👍

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

    നമുക് name vlook ഇട്ട ശേഷം location വീണ്ടും vlookup ഇടാതെ copy paste chayyathelle annit cell number മാറ്റിയാൽ പോരെ

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

    Hi Alfan- ഒരു searchable drop down list ഉണ്ടാക്കുന്ന method പറഞ്ഞുതരുമോ

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

      Sure... Very soon I will upload the video and share with you🙂👍

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

      @@rows_columns Thank you

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

      Adyam search box undaku ennit data whole ayi click go to conditional formatting use the option the last click ennit select search box = data il 1st cell then delete the dollar sign format option click appol fill ennoru option und select colour then ok

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

    Thank you so much

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

    Thanks a lot, the best in youtube.
    One doubt: is there a way to lookup a set of data/ like more than 4/5 columns together?Dragging one formula to other cells give answer NA.

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

      Thanks😊
      Apply absolutely reference & try✌️

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

      @@rows_columns yes that works🙏🏻

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

      @@karthikavarma8970 💫👍😊

    • @MaheshKumar-ww4cy
      @MaheshKumar-ww4cy 2 года назад

      Apply Absolute reference by pressing F4

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

    Sir in the 1st case for finding the location, its against is name, so how can we select the empl number? I didnt understand

  • @hasnarafi5191
    @hasnarafi5191 7 месяцев назад

    Thanks😊

  • @sajithcs-w7u
    @sajithcs-w7u Год назад

    Please share exel sheet

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

    Thank you

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

      Thank you!

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

      Thanks for your feedback and I'm glad it helped 😊
      You can download file used in the video : www.rowscolumns.com/free-excel-templates

  • @jesifasil6760
    @jesifasil6760 2 года назад +1

    Exact എന്തിനാണ് 0 അല്ലെങ്കിൽ false കൊടുക്കുന്നത്

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

      It will treat anything equal to zero (0) as false, anything unequal to zero as true.

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

    താങ്കളുടെ നമ്പർ തരുമോ sir കുറച്ച് സംശയങ്ങൾ ഉണ്ട് ബുദ്ധിമുട്ടില്ലങ്കിൽ മതിട്ടോ

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

      @@sharkwhale1402 send me ur contact details to alfankp86@gmail.com

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

      ഓക്കേ sir

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

    💯💯

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

    Please send spreadsheet

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

    hi Alfan..under vlookup if employee no is in column B and Name is in Column A..how to use the vlookup in this case keeping lookupvalue same as employee no..this is just example from your file, while in many formats we had come across this type of issue..

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

      Hi Kiran, That case we can use either X Look up or Index Match... will share the link soon once I make the video😊

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

      @@rows_columns noted with thanks

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

      🙂🙂

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

    Can you send me an excel sheet?

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

      Sir your help to find look up one colom A captain SKUcolom B cantanin location same sku in different location how can get location sku location first colom, location 2 second colom location 3 third colom etc

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

      Pls give Watsapp no.

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

      @@mohammediqbal2473 9746637500

  • @ArjunS-qm7if
    @ArjunS-qm7if Год назад

    Thank you so much brother