excel magic trick 899: lookup column of data, match criterion, display items vertically
Published 12 years ago • 20K plays • Length 8:31Download video MP4
Download video MP3
Similar videos
-
7:30
excel magic trick 898: lookup row of data and display items vertically: index index lookup formula
-
8:32
excel magic trick 757: two lookup values & 2 lookup columns? great formula index & match
-
3:30
lookup column with choosecols, index or xlookup function? excel magic trick 1835
-
10:33
excel magic trick 1192: match lookup value to closest number in 1st column of lookup table
-
14:46
excel magic trick 986 one lookup value, extract multiple items, display horizontally (a closer look)
-
5:10
excel magic trick 639: approximate match lookup with unsorted column across multiple columns
-
3:10
excel magic trick 873: vlookup - lookup that rounds to the nearest number (increment equal)
-
13:34
how to use the new & improved excel xlookup (with 5 examples)
-
14:13
return multiple match results in excel (2 methods)
-
5:07
excel index match tutorial
-
10:10
excel magic trick 1499: vlookup or index joins to create transaction description (3 examples)
-
4:55
excel magic trick 881: lookup picture with index & match functions instead of indirect function
-
18:07
excel magic trick 1352: lookup 3 items & return to single cell vlookup, index or lookup functions?
-
5:35
excel magic trick 552: display vlookup results vertically
-
3:35
multiple discount lookup tables!?!? lookup & filter functions. excel magic trick 1832
-
7:10
excel magic trick 886: two way lookup, list names in tabular table (row & column criteria)
-
5:11
excel magic trick 1111: item in both lists? extract with better array formula
-
4:17
excel magic trick 1835 part 02: lookup row with choosecols, index, xlookup or filter function?
-
5:32
excel magic trick 688: lookup all values in expanding dynamic row and then add
-
5:53
excel magic trick 931: vlookup & match: lookup values with special characters such as ~ * ?
-
6:05
excel magic trick 922: lookup row, then lookup value in row & return column header: two way lookup
-
13:35
excel magic trick 1483: lookup array formula: lookup correct price based on effective date