Hello,
I tried using the index and match function to solve my issue but could not figure out how to do it.
=INDEX(B$3:D$3,MATCH(MIN(B4:D4),B4:D4,0),MATCH(I4,$A$4:$A$9,0))
I am trying to populate sheet 2 by pulling data from sheet 1.
Steps
Sheet2 first finds matching id in sheet1 then looks at the corresponding columns for lowest value and returns the column header. I have an example of what it should look like in sheet2 below.
I think sumproduct might be able to make this work but i have no idea how to do it.
thanks,
zohaib
I tried using the index and match function to solve my issue but could not figure out how to do it.
=INDEX(B$3:D$3,MATCH(MIN(B4:D4),B4:D4,0),MATCH(I4,$A$4:$A$9,0))
I am trying to populate sheet 2 by pulling data from sheet 1.
Steps
Sheet2 first finds matching id in sheet1 then looks at the corresponding columns for lowest value and returns the column header. I have an example of what it should look like in sheet2 below.
sheet1 | |||
id | apple | orange | grape |
6 | 11 | 23 | 47 |
2 | 51 | 15 | |
4 | 55 | 58 | |
5 | 7 | ||
1 | 22 | 29 | 21 |
3 | 31 | 25 |
sheet2 | |
id | Header |
3 | grape |
1 | grape |
4 | apple |
6 | apple |
2 | grape |
5 | orange |
I think sumproduct might be able to make this work but i have no idea how to do it.
thanks,
zohaib