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