yogi_Pull Multiple MATCH results from one row

Google Spreadsheet   Post  #2464

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jun-22-2018

question by: Kelther
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/Nu5z3DJ3nJg;context-place=forum/docs
Multiple MATCH results from one row?
Is there a way to use Match to get multiple results on one row?

My data is as follows

Name     Apples     Bananas     Oranges     

Alice          1                 3                   4

Bob           3                 3                  2

Charlie       2                 2                  2

I'd like to put in a formula using VLOOKUP and MATCH to determine the following:

What does [VLOOKUP index] have [MATCH Index] of?

What does Alice have 4 of?

What does Bob have 3 of?

What does Charlie have 2 of?

Results:

Alice     Oranges

Bob       Apples      Bananas

Charlie   Apples     Bananas    Oranges

Is there any way to do that?