View Detailed Profile
Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets

Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets

Download

Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)

Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)

Download

Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values

Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT398-405.xls See how to use the VLOOKUP function ...

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Download

Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations

Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT478-479.xls See a robust formula that can handle ...

Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN

Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN

Download

Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Download

Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH

Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH

Download

Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?

Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?

Download

Excel Magic Trick #225: 2 Way Lookup With Duplicates

Excel Magic Trick #225: 2 Way Lookup With Duplicates

Download

Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula

Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula

Download

Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples)

Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples)

Download

Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)

Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)

Download