yogi_Compute Row By Row Minimum Value Along With Corresponding Item In Row 1

Google Spreadsheet   Post  #2276

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-11-2017

question by: Trevor Kitchen

https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!topic/docs/7NwqD0i4WHQ;context-place=forum/docs

helllo google

i am currently working on a price table and want to know if i can get a formula to select the minimum value of a line and quote what column it took the value from

each line being the product for example strawberrys and columns the supplyers ex 'expensive farm' or 'cheaper farm' and 'medium farm' 

so i  would like it to come out with the minimum value and the name of the colum 'cheaper farm' in the same cell or different cell as second formula if necessary

thank you