Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
60,552
Uploaded by contextures on Aug 16, 2008
http://www.contextures.com/xlFunctions03.html
Excel's MATCH function finds items in a list. Combine with VLOOKUP for flexible formulas.
Category:
Tags:
License:
Standard YouTube License
-
25 likes, 1 dislikes
Link to this comment:
Share to:
Uploader Comments (contextures)
see all
All Comments (16)
-
We can also use match and index function.
hvinaykumar 3 months ago
-
how do you get the drop down boxes
Eddiedutube 6 months ago
-
@GodblessHunt Glad you liked the video!
contextures 1 year ago
Loading...
Advertisement
8:18
Combining MATCH and INDEX - Excel for Business - Lesson 2by raycolondotcom23,171 views
5:37
How to Use the VLOOKUP Function in Excelby DannyRocksExcels10,541 views
6:56
How to Use Multiple Pivot Table Summaries in Excel 2007by DannyRocksExcels6,338 views
2:14
Comparing Listsby MrExcel36,408 views
6:57
Find Duplicate Information in an Excel Databaseby moderninconveniences3,980 views
6:45
Linking Data from Different Excel Sheets and Workbooksby ExcelFormulas19,493 views
6:01
How to Lookup Values Using Multiple Columns in Excelby DannyRocksExcels15,763 views
9:56
How to Use VLOOKUP in Microsoft Excel 2010by QuePublishing61,477 views
4:13
Excel Lookup Series #8: MATCH Functionby ExcelIsFun70,456 views
4:56
Excel Lookup Series #12: INDEX & MATCH functions Example 2!by ExcelIsFun42,389 views
4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup valuesby ExcelIsFun35,589 views
4:46
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookupby ExcelIsFun69,039 views
3:15
Excel Lookup Series #9: INDEX function 1st Exampleby ExcelIsFun57,439 views
3:51
Excel Lookup Series #6: HLOOKUP Functionby ExcelIsFun52,085 views
1:31
How to use the MATCH formulaby MHELP2U1,856 views
3:02
Remove the #N/A Error from VLOOKUP in Excelby ExcelisHell24,193 views
2:24
Learn how to use Vlookup in Excel 2007by Learnhowtouseexcel5,813 views
2:47
Excel - Using a combobox Tutorial- Cell Linkby akphidelt101,401 views
3:23
Excel VLOOKUP From Another Workbookby contextures13,807 views
2:08
E1.7 VLOOKUP across two worksheetsby Firchild214,121 views
- Loading more suggestions...
Great vid, took me forever to figure out how to do a vlookup when I had to do a search with an ID w. a combo of text and # 's in a cell, but by using a match feature to reference the ID row number I put it in a different cell and could vlookup that bc it was a #. Very clear and helpful!
mege696 1 year ago
@mege696 Thanks, that Match function is a great help! Glad you liked it.
contextures 1 year ago
Very well explained. Thanks for sharing.
anandvshah1 1 year ago
@anandvshah1 You're welcome! Thanks for your comment.
contextures 1 year ago