excel magic trick 1356: lookup 3 items & return to single cell helper column or power query?
Published 7 years ago • 6.3K plays • Length 11:46Download video MP4
Download video MP3
Similar videos
-
18:07
excel magic trick 1352: lookup 3 items & return to single cell vlookup, index or lookup functions?
-
13:38
excel magic trick 1415: power query lookup and return multiple items and join them in single cell
-
14:46
excel magic trick 986 one lookup value, extract multiple items, display horizontally (a closer look)
-
8:43
excel magic trick 1508: lookup in current table? self join? vlookup or power query?
-
8:46
excel magic trick 1234: vlookup to 36 different tables: helper column w lookup & expandable range
-
18:24
excel magic trick 1372: extract only total row for each name: formula or power query (6 examples)
-
21:20
excel magic trick 1351: power query: merge text & excel files, custom columns, total row & slicer
-
8:32
excel magic trick 757: two lookup values & 2 lookup columns? great formula index & match
-
6:38
excel useful power query with lookup to summary of me - episode 2293
-
4:16
excel power query revelation: two way lookup - episode 2296
-
7:16
excel secrets unveiled: the excel secret decoder ring - episode 2330
-
11:44
power query: lookup 3 lowest prices from 3 criteria lookup table. excel magic trick 1738.
-
21:48
two-way lookup in power query? m code for exact & approximate match lookup. excel magic trick 1554
-
8:24
excel magic trick 360: part 3: return multiple items from one lookup value for row w formula
-
14:14
excel magic trick 1334: power query or formula: lookup name based on max value and more…
-
8:20
excel magic trick 359: part 2: return multiple items from one lookup value for column w formula
-
3:35
multiple discount lookup tables!?!? lookup & filter functions. excel magic trick 1832
-
7:25
power query m code group by formula to transform invoice table - excel magic trick 1576
-
8:42
excel magic trick 1232: vlookup to 36 different tables: power query transforms 36 tables into 1
-
6:55
excel magic trick 1328: case sensitive filtering, adding or counting: power query (get & transform)
-
6:24
excel magic trick 1150: power query: dynamically sum by category without vlookup helper column
-
6:28
excel magic trick 729: vlookup when multiple lookup items in cell, lookup & search functions