Friday, June 22, 2018

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!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?


Alice     Oranges
Bob       Apples      Bananas
Charlie   Apples     Bananas    Oranges

Is there any way to do that?