Video scenes shots:
Watch the video:
| URL: | |
| Embed: |
Other videos by this author:
 |
Excel Magic Trick 922: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup Posted by: ExcelIsFun
Video duration: 365 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See how to use two lookup values to lookup (Number In Household) a row in a table, then lookup a value (Income) within the row that was just looked-up, and then return the column header (a percentage) using Two INDEX functions and Two MATCH Functions in one formula. |
 |
Excel Magic Trick 918: Upside down VLOOKUP: Sort Decending & Bump Into First Smallest Value Posted by: ExcelIsFun
Video duration: 404 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See how to Do a lookup that finds the smallest value that is greater than or equal to lookup_value using the INDEX function and a -1 (minus one) in the 3rd argument of the MATCH function, or said a different way: Upside down VLOOKUP: Sort 1st Column Decending & Bump Into First Smallest Value, then jump back a row. |
 |
Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet Posted by: ExcelIsFun
Video duration: 497 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See how to: 1. Select From Drop Down and Pull Data From Different Sheets using Data Validation List, the INDIRECT Function, and the join symbol ampersand & 2. Learn about syntax for Sheet References 3. INDIRECT Function 4. Data Validation Drop Down List |
 |
Excel Magic Trick 911: Add Leading Zero and Dash, More Examples From Mr Excel & excelisfun Trick 107 Posted by: ExcelIsFun
Video duration: 481 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm SchultzesBlues and Daniel1Dion at YouTube give great examples of how to add a leading zero and dash to a number using the REPLACE function and Custom Number Formatting, Related to this video: Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers |
 |
Excel Magic Trick 910: Adding with AND, BETWEEN and OR Criteria: SUMIFS and COUNTIF Functions Posted by: ExcelIsFun
Video duration: 323 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See how to Adding with AND, BETWEEN and OR Criteria with SUMIFS function for AND criteria and 2 COUNTIF functions for OR criteria. |
 |
Mr Excel & excelisfun Trick 106: LOOKUP Function in VisiCalc, Lotus and Excel Posted by: ExcelIsFun
Video duration: 611 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See Mr Excel and excelisfun talk about LOOKUP in VisiCalc, Lotus and Excel |
 |
Mr Excel & excelisfun Trick 105: Count Between Words Posted by: ExcelIsFun
Video duration: 484 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See Mr Excel and excelisfun use two methods to count between words using formulas and VBA. INDEX and MATCH and COUNTA functions to count between words |
