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
AWESTOME... BEEN LOOKING FOR THIS TUTORIAL FOR YEARS!!!!!
You have NO IDEA how much you helped me with this video 🙏🏻
Conocer de las opciones, complementa y nos ayuda a resolver necesidades. Gracias !!!!!
Amazing explanation in all your videos! Thank you for your work!
@ExcelGoogleSheets
4 жыл бұрын
Thanks!
Thanks so much. What a nice tutorial.
Thanks for the sharing... Learn something useful especially I can use it for data analysis after combine my data
Thank you so much!
Thanks a lot ....it really helpful
How can we buy you a coffee ? great job man !!
can you include a link to the files you are using in your videos ? That would be helpful for practicing...thanks
Thank you the video was very helpful.
@ExcelGoogleSheets
2 жыл бұрын
Glad to hear it!
Thank you so much. I wish I saw this a year a go before building macros😱
@ExcelGoogleSheets
2 жыл бұрын
🙂
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
2 жыл бұрын
Select the smaller table first and then use left outer join.
Thank u so much sir
Really good. Great? Yes ok, this is great!
@ExcelGoogleSheets
2 жыл бұрын
:)
U just helped me coz vlookup was not working for me
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?
TEXTJOIN started with Office 365, Office 2016 and earlier don't have this function.
@ExcelGoogleSheets
4 жыл бұрын
Cool, thanks. I couldn't remember if it was 2013 or 2016.
works in Google sheet as well?
@ExcelGoogleSheets
4 жыл бұрын
Google Sheets version kzread.info/dash/bejne/kaV5xZp8dcq7nJc.html
@chaejongseik
4 жыл бұрын
@@ExcelGoogleSheets Gracias
thanks for making this video, but it was too long, and the example is hard.
How do i make an excel where i can search for multiple result with 4 criterias?
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
4 жыл бұрын
These videos should help you kzread.info/dash/bejne/foWZybmcnbHXfpM.html kzread.info/dash/bejne/amV5sbyvZb2TmdI.html
@mikemike-vi8cp
4 жыл бұрын
@@ExcelGoogleSheets THANKS CLOSE BUT NOT THAT
text
text