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

  Рет қаралды 24,854

Learn Google Sheets & Excel Spreadsheets

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Пікірлер: 38
@vitalv-twincycles757
@vitalv-twincycles757 7 ай бұрын
AWESTOME... BEEN LOOKING FOR THIS TUTORIAL FOR YEARS!!!!!
@katiabernini6046
@katiabernini6046 2 жыл бұрын
You have NO IDEA how much you helped me with this video 🙏🏻
@theresawongmy
@theresawongmy 4 жыл бұрын
Thanks for the sharing... Learn something useful especially I can use it for data analysis after combine my data
@josedejesusfragozolopez6396
@josedejesusfragozolopez6396 4 жыл бұрын
Conocer de las opciones, complementa y nos ayuda a resolver necesidades. Gracias !!!!!
@taherehdehdarirad1605
@taherehdehdarirad1605 3 жыл бұрын
Thanks so much. What a nice tutorial.
@mykolalazarenko
@mykolalazarenko 4 жыл бұрын
Amazing explanation in all your videos! Thank you for your work!
@ExcelGoogleSheets
@ExcelGoogleSheets 4 жыл бұрын
Thanks!
@momforone7946
@momforone7946 2 жыл бұрын
Thank you so much. I wish I saw this a year a go before building macros😱
@ExcelGoogleSheets
@ExcelGoogleSheets 2 жыл бұрын
🙂
@mypalmjumeirah1627
@mypalmjumeirah1627 3 жыл бұрын
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 жыл бұрын
Select the smaller table first and then use left outer join.
@Lyriks_
@Lyriks_ 2 жыл бұрын
How can we buy you a coffee ? great job man !!
@muhammadwaqar2423
@muhammadwaqar2423 2 жыл бұрын
Thank you the video was very helpful.
@ExcelGoogleSheets
@ExcelGoogleSheets 2 жыл бұрын
Glad to hear it!
@aybilal6279
@aybilal6279 3 жыл бұрын
Thank you so much!
@user-cx2bk6pm2f
@user-cx2bk6pm2f 2 жыл бұрын
Really good. Great? Yes ok, this is great!
@ExcelGoogleSheets
@ExcelGoogleSheets 2 жыл бұрын
:)
@zinhlezwane8353
@zinhlezwane8353 2 жыл бұрын
U just helped me coz vlookup was not working for me
@tetocaloscojones8229
@tetocaloscojones8229 3 жыл бұрын
can you include a link to the files you are using in your videos ? That would be helpful for practicing...thanks
@sahilpoweroftrading
@sahilpoweroftrading 3 жыл бұрын
Thanks a lot ....it really helpful
@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?
@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.
@bradhabeeb306
@bradhabeeb306 Жыл бұрын
thanks for making this video, but it was too long, and the example is hard.
@chaejongseik
@chaejongseik 4 жыл бұрын
works in Google sheet as well?
@ExcelGoogleSheets
@ExcelGoogleSheets 4 жыл бұрын
Google Sheets version kzbin.info/www/bejne/laKolGt5esyIopY
@chaejongseik
@chaejongseik 4 жыл бұрын
@@ExcelGoogleSheets Gracias
@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 kzbin.info/www/bejne/goLImIqZorOkhJI kzbin.info/www/bejne/bmKogI2sar9gn9E
@mikemike-vi8cp
@mikemike-vi8cp 4 жыл бұрын
@@ExcelGoogleSheets THANKS CLOSE BUT NOT THAT
@cwtqvsdbkvsbqjubojre7100
@cwtqvsdbkvsbqjubojre7100 2 жыл бұрын
text
@cwtqvsdbkvsbqjubojre7100
@cwtqvsdbkvsbqjubojre7100 2 жыл бұрын
text
Excel Tables - Formulas, Basic to Advanced
31:35
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 34 М.
Excel - Clean Messy Data using Fuzzy Match - Power Query
12:55
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 10 М.
Миллионер | 3 - серия
36:09
Million Show
Рет қаралды 1,6 МЛН
How to Link to Other Spreadsheets (Files) in Excel & Google Sheets
21:34
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 19 М.
6 COOLEST  Excel formulas in 2024
7:57
FM Lifestyle
Рет қаралды 10 М.
DGET - Powerful VLOOKUP, INDEX-MATCH Replacement - Google Sheets Tutorial
15:54
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 121 М.
VLOOKUP Multiple Matching Results in Excel
14:35
PowerEx by Jitendra
Рет қаралды 33 М.
You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯
12:17
Combine Data from Multiple Google Sheets Documents (Workbooks) in Google Drive into One Workbook
28:32
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 77 М.
10 Excel Things You Should NEVER Do and What to do Instead
12:34
MyOnlineTrainingHub
Рет қаралды 591 М.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,4 МЛН