excel magic trick 1375 add w or logical test from 2 different columns in 2 diff. tables (6 examples)
Published 7 years ago • 11K plays • Length 55:04Download video MP4
Download video MP3
Similar videos
-
7:24
excel magic trick 764: choose function to "mash" columns together to create lookup tables
-
9:00
excel magic trick 1307: conditionally format multiple non-adjacent cells in cross tabulated table
-
15:52
excel magic trick 1316: vlookup with multiple lookup tables: if, indirect, switch, ifs, or choose?
-
10:51
excel magic trick 1400: conditionally format row in class enrollment table with complex criteria
-
5:10
excel magic trick 999: match rather than or function to conditionally format row with or criteria
-
14:46
excel magic trick 986 one lookup value, extract multiple items, display horizontally (a closer look)
-
7:07
excel magic trick 588: 2 vlookup functions looking into 2 different tables
-
15:08
excel magic trick 1009: lookup 3 different arrays from 3 different tables: vlookup, choose, index
-
8:24
excel magic trick 360: part 3: return multiple items from one lookup value for row w formula
-
19:34
excel magic trick 1400 part 2: conditionally format row with complex criteria (3 more examples)
-
20:43
excel magic trick 1381: power query: records in column into table then two different top 3 reports
-
19:49
excel magic trick 1285: or criteria & and criteria for max & min calculations (5 examples)
-
15:03
excel magic trick 762: two way lookup from multiple tables & lookup tables sorted descending
-
4:00
excel magic trick 1384: import excel table or sheet in power query or power bi?