Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each List
Loading...
Loading...
24,490
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (18)
-
How do you compare 2 lists when 1 list has only words, but the 2nd list has words and numbers?
For example A1: Spiderman, B1: Spiderman (2002), C1: TRUE (because the word Spiderman was found)??????
-
I know the best course of magic
-
I am glad that it helped!!
-
Awesome!! this did exactly what i needed!!
Loading...
4:27
Excel Magic Trick 381: Merge Two Lists Tables w Advanced Filter and Remove Duplicates Featureby ExcelIsFun15,591 views- 2:28
Excel Magic Trick #245: Matching 2 Lists w IF & OR functionsby ExcelIsFun8,495 views
- 7:17
Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functionsby ExcelIsFun11,266 views
- 10:07
Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twiceby ExcelIsFun16,904 views
- 7:34
Excel Magic Trick 606: INDEX & MATCH Two Lookup Valuesby ExcelIsFun15,031 views
- 2:14
Comparing Listsby MrExcel36,408 views
- 3:17
Merging (Joining) two worksheets based on common column values using ActiveData For Excelby ActiveDataForExcel22,426 views
- 1:35
Excel lookup with multiple conditions! (extended vlookup)by Psychotec13,103 views
- 4:46
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookupby ExcelIsFun69,039 views
- 4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup valuesby ExcelIsFun35,062 views
- 6:54
Consolidating Data from Multiple Excel Worksheets By Positionby DannyRocksExcels23,058 views
- 6:59
Excel Lookup Series #7: LOOKUP Functionby ExcelIsFun35,430 views
- 4:18
How to Create a Searchable Database - Step 1 of 3: Importing Databy CaspioInc24,608 views
- 4:13
Excel Lookup Series #8: MATCH Functionby ExcelIsFun70,456 views
- 7:56
Search & Find Excel Videos, Playlists, Download Workbooks - excelisfunby ExcelIsFun11,253 views
- 6:41
Excel Lookup Series #2: VLOOKUP Function 2nd Exampleby ExcelIsFun125,173 views
- 0:56
Compare data between two Excel Spreadsheetsby citrustechnology7,936 views
- 8:18
Combining MATCH and INDEX - Excel for Business - Lesson 2by raycolondotcom23,171 views
- 6:28
Excel Magic Trick 577: Find Duplicates, Then Extract Unique Recordsby ExcelIsFun9,888 views
- 7:46
Excel Magic Trick 185.5 Advanced Filter Data Extract 1criterby ExcelIsFun21,175 views
I thought I'd I need to download some software to solve the problem, because the Microsoft help files really didn't help. Your way of doing this is really neat. I'm very very grateful.
slimwett 6 months ago
You are welcome!
ExcelIsFun 6 months ago
Thankyou sir, it was really helpful for me. With best regards. Tushar
jainmanpreet 7 months ago
You are welcome!
ExcelIsFun 7 months ago
Thank you soo much great help:)))
Davut16 1 year ago
You are welcome!
ExcelIsFun 10 months ago