Need a formula to pull values into column A based on the corresponding values in B and C. Actual data is in column F through H.
In column C, large function was used to extract the largest to the smallest values - based on values in column H. Corresponding region values were pulled. Need a formula to pull the corresponding product list in A - desired outcome is highlighted in yellow in A.
Sample workbook attached.
Bookmarks