Excel Is Fun / High School / Computer Technology
Lecture : Highline Excel Class 45: INDEX function and MATCH function 12 Unusual Examples
By Multiple Instructors | Excel 2010 – Intermediate to Advance
Lecture 45 of 59
Rate this lecture -
 More Lectures - Select Lecture...1 : Highline Excel Class 01: Back To Basics2 : Highline Excel Class 02: Excel Formulas and Excel Functions3 : Highline Excel Class 03: Names, Cell References, Formula Inputs4 : Highline Excel Class 04: Style and Number Format and ROUND5 : Highline Excel Class 05: Charts, Page Setup, Data Analysis6 : Highline Excel Class 06: Worksheet and Workbook References7 : Highline Excel Class 07: VLOOKUP function formula 7 Examples8 : Highline Excel Class 08: 3-D Cell References Add Across Sheets9 : Highline Excel Class 09: SUMIF Function Formula 3 Examples10 : Highline Excel Class 10: VLOOKUP SUMIF and Percentage Increase11 : Highline Excel Class 11: Logical formulas, IS and IF functions12 : Highline Excel Class 12: DATE functions and Formulas13 : Highline Excel Class 13: Text functions and AMPERSAND14 : Highline Excel Class 14: How To Setup Data in Excel15 : Highline Excel Class 15: Excel 2007 Tables 7 Examples16 : Highline Excel Class 16: Sort, Sorting 10 Examples17 : Highline Excel Class 17: Filter, Filtering 8 Examples18 : Highline Excel Class 18: Subtotals19 : Highline Excel Class 19: Advanced Filter Extract Data 9 Examples20 : Highline Excel Class 20: Pivot Tables 20 Examples21 : Highline Excel Class 21: Conditional Formatting 12 Examples22 : Highline Excel Class 22: Budgets, Scenarios and Scenarios Report23 : Highline Excel Class 23: Import Different Types of Data24 : Highline Excel Class 24: Order Of Precedents25 : Highline Excel Class 25: Fix Problems and Errors In Spreadsheet26 : Highline Excel Class 26: Fixing Other Peoples Spreadsheets27 : Highline Excel Class 27: Custom Number Format and TEXT function28 : Highline Excel Class 28: More Excel Basics Review29 : Highline Excel Class 29: Basic Statistics Numerical Measures30 : Highline Excel Class 30: SUMIF, RANK and Bonuses31 : Highline Excel Class 31: Histogram and LARGE SMALL functions32 : Highline Excel Class 32: More Charts and SUMIFS and AVERAGEIFS33 : Highline Excel Class 33: IF AND OR Customer Credit Analysis34 : Highline Excel Class 34: IF function Formula Payroll Formula35 : Highline Excel Class 35: IF Function Vs. VLOOKUP Function36 : Highline Excel Class 36: Array Formulas Basics37 : Highline Excel Class 37: SUMPRODUCT function38 : Highline Excel Class 38: Array Functions TRANSPOSE FREQUENCY39 : Highline Excel Class 39: Forcing Functions To Become Arrays40 : Highline Excel Class 40: VLOOKUP 11 Unusual Examples41 : Highline Excel Class 41: HLOOKUP ROWS Horizontal Lookup42 : Highline Excel Class 42: Versatile LOOKUP function 10 Examples43 : Highline Excel Class 43: MATCH function44 : Highline Excel Class 44: Basics of INDEX and MATCH functions45 : Highline Excel Class 45: INDEX function and MATCH function 12 Unusual Examples46 : Highline Excel Class 46: CHOOSE function 4 Examples47 : Highline Excel Class 47: PMT function 5 Examples48 : Highline Excel Class 48: Interest Rates 6 Examples49 : Highline Excel Class 49: Spreadsheet To Compare Loans50 : Highline Excel Class 50: Value Asset: PV NPV and XNPV function51 : Highline Excel Class 51: Life Time Savings Plan52 : Highline Excel Class 52: Recorded Macro Basics53 : Highline Excel Class 53: Relative and Absolute Macro Recorde54 : Highline Excel Class 54: Excel VBA code From Internet55 : Highline Excel Class 52.5: Macro Security56 : Excel Magic Trick 253: Data Table 1 Variable What If Analysis57 : Excel Magic Trick 254: Data Table Creates 100 Formulas58 : Excel Magic Trick 255: Data Table 2 Variable What If Analysis59 : YTLE103: Excel Goal Seek

Course Description

This lecture is part of Excel 2010 – Intermediate to Advance by Multiple Instructors , does not currently have a detailed description. Please help us by commenting on this lecture in lectures section with your suggestions. Many thanks from , MyEducationKey Team

Courses Index
1 : Powerpoint 2010 – Intermediate to Advance   (Multiple Instructors / TeachUCompInc)
2 : Powerpoint 2010 – Multimedia Capabilities   (Guy Vacarro / IFSKILLS)
3 : MS Project Tutorials   (Multiple Instructors / TeachUCompInc)