+ Reply to Thread
Results 1 to 2 of 2

Matching Two Separate Data Sets to Each Other

  1. #1
    Registered User
    Join Date
    10-09-2019
    Location
    Los Angeles, CA
    MS-Off Ver
    2017
    Posts
    12

    Matching Two Separate Data Sets to Each Other

    Hi,

    I am trying to match two separate sets of data - one has bakeries in it. The other has customers. I want to be able to choose a specific customer, and have it return the customers that match any of their interests.

    For instance, in the attached document, I have the Customer Selector tab, where I have chosen Rose. Rose likes Cakes and Donuts, so I want to return all bakeries that make Cakes OR Donuts: which would be Abby's Bakery, Dorothy's Donuts, and Eli's Dessert Shop.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,683

    Re: Matching Two Separate Data Sets to Each Other

    Please try at D4
    =IFERROR(INDEX('Bakery Data'!$B:$B,AGGREGATE(15,6,ROW('Bakery Data'!$B$6:$B$10)/(MMULT(--(EXACT(INDEX(Customers!$C$6:$K$8,MATCH($C4,Customers!$B$6:$B$8,),),'Bakery Data'!$G$6:$O$10)),ROW(Customers!$A$1:INDEX(Customers!A:A,COLUMNS(Customers!$C$5:$K$5)))^0)>0),COLUMNS($D4:D4))),"")

    Drag to the right
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1