Find Multiple Match Results in Excel - Return What VLOOKUP Won't

Поділитися
Вставка
  • Опубліковано 20 січ 2025

КОМЕНТАРІ • 39

  • @vitalv-twincycles757
    @vitalv-twincycles757 9 місяців тому

    AWESTOME... BEEN LOOKING FOR THIS TUTORIAL FOR YEARS!!!!!

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

    You have NO IDEA how much you helped me with this video 🙏🏻

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

    Amazing explanation in all your videos! Thank you for your work!

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

    Thanks for the sharing... Learn something useful especially I can use it for data analysis after combine my data

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

    How can we buy you a coffee ? great job man !!

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

    Thanks so much. What a nice tutorial.

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

    Conocer de las opciones, complementa y nos ayuda a resolver necesidades. Gracias !!!!!

  • @rgreene1954
    @rgreene1954 Місяць тому

    Brilliant !! Thank You

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

    Thank you for the video very helpful, I have 2 sheets in one excel, 1 with 754 and sheet 2 with 10,000 entries. I have managed to merge the data but it has also added all of the remaining 10,000 into the merge. How can I do a merge that only merges the matching number in the cell?

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

      Select the smaller table first and then use left outer join.

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

    Thank you so much. I wish I saw this a year a go before building macros😱

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

    Thank you the video was very helpful.

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

    Thank you so much!

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

    Thanks a lot ....it really helpful

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

    can you include a link to the files you are using in your videos ? That would be helpful for practicing...thanks

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

    works in Google sheet as well?

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

      Google Sheets version ua-cam.com/video/_qEc8CEgUl4/v-deo.html

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

      @@ExcelGoogleSheets Gracias

  • @user-cx2bk6pm2f
    @user-cx2bk6pm2f 3 роки тому

    Really good. Great? Yes ok, this is great!

  • @GR..._
    @GR..._ 3 роки тому

    Thank u so much sir

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

    TEXTJOIN started with Office 365, Office 2016 and earlier don't have this function.

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

      Cool, thanks. I couldn't remember if it was 2013 or 2016.

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

    Good afternoon my dear. First congratulations on the work. Very good your videos. I am suffering trying to make a login screen using google app script and google spreadsheet as a bank. Can you give me a short example?

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

    U just helped me coz vlookup was not working for me

  • @bradhabeeb306
    @bradhabeeb306 Рік тому

    thanks for making this video, but it was too long, and the example is hard.

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

    How do i make an excel where i can search for multiple result with 4 criterias?

  • @mikemike-vi8cp
    @mikemike-vi8cp 4 роки тому

    HI GUYS AND LADIES
    ONE QUESTION
    I HAVE TWO TABLES
    AS SHOWN
    1 2 3 5 1 2 3 4 5
    .....
    LEFT SIDE 4 COLUMNS RIGHT TABLE 5 COLUMNS
    THOUSANDS OF ROWS
    I WANT TO FIND IN RIGHT TABLE HOW MANY TIME AND WHERE IS EXACT MACHT OF LEFT TABLE
    IN ALL ROWS
    WHICH FUNCTION TO USE PLEASE AND HOW
    THANK YOU

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

      These videos should help you
      ua-cam.com/video/LQegWcmNqN0/v-deo.html
      ua-cam.com/video/81EOZv5Z-io/v-deo.html

    • @mikemike-vi8cp
      @mikemike-vi8cp 4 роки тому

      @@ExcelGoogleSheets THANKS
      CLOSE BUT NOT THAT

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

    text

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

    text