Is there any way in Excel to look for the max value of column 5 and return the value in column 3?
M Martin Jun 12, 2008 #1 Is there any way in Excel to look for the max value of column 5 and return the value in column 3?
S Sasa Stankovic Aug 16, 2008 #2 enter this formula: =lookup(max(E1:e10),e1:e10,c1:c10) this way excel will search for maximum value in cells e1 to e10 (replace with your range) and return value from column C. hope it works for you sasa stankovic
enter this formula: =lookup(max(E1:e10),e1:e10,c1:c10) this way excel will search for maximum value in cells e1 to e10 (replace with your range) and return value from column C. hope it works for you sasa stankovic
