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!
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
Does anyone know how to do this on Google Sheets?
You may want to look at the members list and find one or two moderators whom you could PM with a request to move this thread to the 'Other Platforms' forum.
Let us know if you have any questions.
Moderator Comment: Moved as suggested.
Last edited by alansidman; 11-02-2019 at 06:30 AM.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks