Return Multiple Items with One Lookup Value with Power Query

preview_player
Показать описание
Usually when doing a lookup you just want to get one value to come back as a result. However sometime you may have multiple values that you'd want to report back based of some lookup value. There's a couple ways to do this, like filtering (basic and advanced), but Excel is a tool that can give you many ways to do the similar things. This is a video that will show you how to do this task using Power Query. see the video to learn how.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel
  1. Doug H
  2. doug
  3. columns
  4. formula
  5. lookup
  6. excel youtube channel
Рекомендации по теме
Return Multiple Items 0:05:34

Return Multiple Items with One Lookup Value with Power Query

Lookup & Return 0:06:51

Lookup & Return Multiple Values in One Cell in Excel (Easy Formula)

Return Multiple Items 0:09:41

Return Multiple Items with One Lookup Value

Return Multiple Match 0:14:13

Return Multiple Match Results in Excel (2 methods)

Excel VLookup to 0:06:55

Excel VLookup to Return Multiple Matches

Excel Magic Trick 0:07:11

Excel Magic Trick 1311: Return Multiple Items from One Lookup Value & Show Total for Invoice Ite...

Lookup and Return 0:06:28

Lookup and Return Multiple Results into One Cell Separated by Comma or Similar Delimiter

One Lookup Value, 0:01:44

One Lookup Value, Return Multiple Items – The Easy Way with FILTER - Excel Magic Trick 1591

Excel Magic Trick 0:13:38

Excel Magic Trick 1415: Power Query Lookup and Return Multiple Items And Join Them In Single Cell

Return Multiple Items 0:05:16

Return Multiple Items into Comma Separated Values with One Lookup Value

VLOOKUP All Matches 0:04:02

VLOOKUP All Matches with this Crazy Simple Trick

XLOOKUP - Return 0:07:56

XLOOKUP - Return Multiple Columns (Values) in Excel

Highline Excel 2016 0:09:03

Highline Excel 2016 Class 13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE

How to Return 0:05:43

How to Return Multiple Items to Amazon (Group Return)

Lookup & Return 0:01:26

Lookup & Return Multiple Values in Single Cell in Excel (NO VBA | Easy Dynamic Array Formula)

Excel Magic Trick 0:05:12

Excel Magic Trick 1282: Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function

XLOOKUP Only Returns 0:02:29

XLOOKUP Only Returns First Value | XLOOKUP Return all Matches Vertically Or All Matches in One Cell

Return Multiple Values 0:05:01

Return Multiple Values with Single Xlookup Statement

Mr Excel & 0:11:00

Mr Excel & excelisfun Trick 183: Lookup and Return Multiple Items And Join Them In Single Cell

Find Multiple Match 0:12:51

Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)

Return Multiple Values 0:03:48

Return Multiple Values From A Function | Python Tutorial

LOOKUP & Return 0:01:03

LOOKUP & Return Multiple Values in One Cell in #Excel (Separated By Comma) | Daily Excel Hacks

MS Excel LOOKUP 0:01:00

MS Excel LOOKUP Formula: Return Multiple Values

Excel FILTER Function 0:09:22

Excel FILTER Function - Lookup to Return Multiple Values

Комментарии
Автор

Spent a week and half trying to figure this one out, you are a legend mate!!

nnlxyph
Автор

This is MAJOR for me, damn wish I knew this before, would have impressed the bosses so much. Now I’ve got this tool under my belt there is no stopping me, you are a Godsend, thanks

TruthofDilly
Автор

Thanks for sharing this! You saved many hours of work :)

bitucoo
Автор

Damn! so good to see this! but, how can all be extracted from the number source to show all data? please help on this matter! Much apprecieated.

casper