How to use the XLOOKUP function in Excel

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

КОМЕНТАРІ • 29

  • @LaToyaParker-fw3tv
    @LaToyaParker-fw3tv 7 місяців тому +5

    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?

  • @gailodell1277
    @gailodell1277 7 днів тому +1

    Your videos are very helpful and easy to follow. Please make more videos on the differences in using one formula vs. another that return the same results.

  • @shreshthsanjay1702
    @shreshthsanjay1702 4 місяці тому +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! ❤

  • @daniellenunes7858
    @daniellenunes7858 2 роки тому +5

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

  • @jaganmohan4160
    @jaganmohan4160 8 місяців тому +1

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

    • @Techonthenetcom
      @Techonthenetcom  8 місяців тому +1

      As another option, you can also use the VLOOKUP function:
      ua-cam.com/video/ODZfwD39gGE/v-deo.html

  • @TheDude-vx6wn
    @TheDude-vx6wn 18 днів тому +1

    You're amazing! Thank you!

  • @dravyamsekhsaria5331
    @dravyamsekhsaria5331 Рік тому +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

  • @saranj9575
    @saranj9575 2 роки тому +2

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

  • @rn4005
    @rn4005 3 роки тому +8

    Thanks a lot, it helped me much :)

  • @irenesimovic1024
    @irenesimovic1024 Рік тому +3

    Super helpful! Thank you

  • @dhrubasardar8315
    @dhrubasardar8315 2 роки тому +2

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

  • @victorbassey223
    @victorbassey223 3 роки тому +2

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

    • @Techonthenetcom
      @Techonthenetcom  3 роки тому +3

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

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

    Merry Merry helpfully

  • @alidrissi3906
    @alidrissi3906 24 дні тому

    This may sound stupid. Why go through all that when the product id is right next to the product?

  • @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:
      ua-cam.com/video/2L5DMoarEsM/v-deo.html

  • @MrUDHAYA1988
    @MrUDHAYA1988 3 роки тому +2

    Thanks.

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

    Thanks

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

    Thanks 👍

  • @7s9n
    @7s9n 3 роки тому +2

    💛💛

  • @dalebrooks4912
    @dalebrooks4912 8 місяців тому

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

    • @Techonthenetcom
      @Techonthenetcom  8 місяців тому

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

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

    Thanks!