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

Learn how to find & return multiple matches in Microsoft Excel. We'll cover how to lookup more than one matching value, then place the results into separate columns, return results in a comma separated list or in separate rows similar to SQL JOIN results. Basically everything that VLOOKUP & INDEX, MATCH are not able to do.
#excel #multiple #match

Пікірлер: 38

  • @vitalv-twincycles757
    @vitalv-twincycles7573 ай бұрын

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

  • @katiabernini6046
    @katiabernini6046 Жыл бұрын

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

  • @josedejesusfragozolopez6396
    @josedejesusfragozolopez63964 жыл бұрын

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

  • @mykolalazarenko
    @mykolalazarenko4 жыл бұрын

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

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    4 жыл бұрын

    Thanks!

  • @taherehdehdarirad1605
    @taherehdehdarirad16053 жыл бұрын

    Thanks so much. What a nice tutorial.

  • @theresawongmy
    @theresawongmy3 жыл бұрын

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

  • @aybilal6279
    @aybilal62793 жыл бұрын

    Thank you so much!

  • @sahilpoweroftrading
    @sahilpoweroftrading3 жыл бұрын

    Thanks a lot ....it really helpful

  • @Lyriks_
    @Lyriks_2 жыл бұрын

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

  • @tetocaloscojones8229
    @tetocaloscojones82293 жыл бұрын

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

  • @muhammadwaqar2423
    @muhammadwaqar24232 жыл бұрын

    Thank you the video was very helpful.

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    2 жыл бұрын

    Glad to hear it!

  • @momforone7946
    @momforone79462 жыл бұрын

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

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    2 жыл бұрын

    🙂

  • @mypalmjumeirah1627
    @mypalmjumeirah16272 жыл бұрын

    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

    2 жыл бұрын

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

  • @GR..._
    @GR..._3 жыл бұрын

    Thank u so much sir

  • @user-cx2bk6pm2f
    @user-cx2bk6pm2f2 жыл бұрын

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

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    2 жыл бұрын

    :)

  • @zinhlezwane8353
    @zinhlezwane83532 жыл бұрын

    U just helped me coz vlookup was not working for me

  • @diegocaixeta8848
    @diegocaixeta88484 жыл бұрын

    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?

  • @lazalazarevic6192
    @lazalazarevic61924 жыл бұрын

    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.

  • @chaejongseik
    @chaejongseik4 жыл бұрын

    works in Google sheet as well?

  • @ExcelGoogleSheets

    @ExcelGoogleSheets

    4 жыл бұрын

    Google Sheets version kzread.info/dash/bejne/kaV5xZp8dcq7nJc.html

  • @chaejongseik

    @chaejongseik

    4 жыл бұрын

    @@ExcelGoogleSheets Gracias

  • @bradhabeeb306
    @bradhabeeb306 Жыл бұрын

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

  • @dfourth7156
    @dfourth71563 жыл бұрын

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

  • @mikemike-vi8cp
    @mikemike-vi8cp4 жыл бұрын

    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 kzread.info/dash/bejne/foWZybmcnbHXfpM.html kzread.info/dash/bejne/amV5sbyvZb2TmdI.html

  • @mikemike-vi8cp

    @mikemike-vi8cp

    4 жыл бұрын

    @@ExcelGoogleSheets THANKS CLOSE BUT NOT THAT

  • @cwtqvsdbkvsbqjubojre7100
    @cwtqvsdbkvsbqjubojre71002 жыл бұрын

    text

  • @cwtqvsdbkvsbqjubojre7100
    @cwtqvsdbkvsbqjubojre71002 жыл бұрын

    text