How to use the XLOOKUP function in Excel

Поделиться
HTML-код
  • Опубликовано: 22 окт 2021
  • 0:32 - VERTICAL lookup example
    2:21 - HORIZONTAL lookup example
    Learn how to use the XLOOKUP function which is the next generation lookup function in Microsoft Excel. The XLOOKUP function has the functionality of both the VLOOKUP as well as the HLOOKUP functions, without the limitations.
    This tutorial demonstrates how to use Excel XLOOKUP with our easy to follow examples and takes you through how to perform a vertical lookup as well as a horizontal lookup.
    XLOOKUP Function (and sample data):
    www.techonthenet.com/excel/fo...
    How to use the VLOOKUP function in Excel:
    • How to use the VLOOKUP...
    www.techonthenet.com/excel/fo...
    How to use the HLOOKUP function in Excel:
    • How to use the HLOOKUP...
    www.techonthenet.com/excel/fo...
    Excel Functions/Formulas:
    www.techonthenet.com/excel/fo...
    Excel Tutorials:
    www.techonthenet.com/excel/in...
    Don't forget to subscribe to our channel for more great Excel tutorials!
    Visit us at: www.techonthenet.com
    or follow us on:
    Facebook: / techonthenetcom
    Twitter: / tech_on_the_net
    Pinterest: / techonthenetcom

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

  • @shreshthsanjay1702
    @shreshthsanjay1702 Месяц назад +1

    This channel has very few videos but is literally a gem!! Please make more videos on excel or any related tools
    Your tutorials are very precise and great! ❤

  • @LaToyaParker-fw3tv
    @LaToyaParker-fw3tv 3 месяца назад +4

    Definitely the best videos in my opinion explaining XLOOKUP and HLOOKUP. All the others I watched was really confusing. you made it really simple and easy to understand! Thank you so much! Have you made a video on HLOOKUP approximation?

  • @daniellenunes7858
    @daniellenunes7858 2 года назад +5

    This video helped me the most. I watched so many videos and didn't get it. Now I do!

  • @irenesimovic1024
    @irenesimovic1024 Год назад +3

    Super helpful! Thank you

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

    Thanks 👍

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

    i love all your excel tutorial. ♥️♥️♥️

  • @dawid_dahl
    @dawid_dahl Год назад +1

    Thanks!

  • @rn4005
    @rn4005 2 года назад +8

    Thanks a lot, it helped me much :)

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

    Thanks.

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

    Merry Merry helpfully

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

    Thanks

  • @dravyamsekhsaria5331
    @dravyamsekhsaria5331 10 месяцев назад +2

    Couldnt understand sumif,and the lookups. But when i saw one of ur videos i understood u r the best. Thank You. Tomorrow i have exam

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

    This channel is great👍👍👍👏👏👏.... Really

  • @jaganmohan4160
    @jaganmohan4160 5 месяцев назад +1

    very help full. and easy to understand . please share the updated video for other option also

    • @Techonthenetcom
      @Techonthenetcom  5 месяцев назад +1

      As another option, you can also use the VLOOKUP function:
      ruclips.net/video/ODZfwD39gGE/видео.html

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

    m=Thanks, but mine didn't return. Is Xlookup a new formula, as excel did not populate it?

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

      Yes, XLOOKUP is new to Excel. You can find it in Office 365 and Excel 2019 and higher

  • @heidi-hu1tv
    @heidi-hu1tv Год назад +1

    Do you have a video on filtering and sorting?

    • @Techonthenetcom
      @Techonthenetcom  Год назад +2

      Here is our video on sorting in Excel:
      ruclips.net/video/2L5DMoarEsM/видео.html

  • @7s9n
    @7s9n 2 года назад +2

    💛💛

  • @dalebrooks4912
    @dalebrooks4912 5 месяцев назад

    I just can’t get this to work #VALUE everytime!

    • @Techonthenetcom
      @Techonthenetcom  5 месяцев назад

      The XLOOKUP function works in Excel 2019 and Excel for Office 365. Could you be running an older version of Excel?