Hi everyone. I would appreciate your help.
I have a workbook with multiple sheets.
in the sheet1 i must return the value from the sheet by the folowing criteria>
suppose o sheet1 i select name 'John', and from the sheet2 that has the structure, i must return the addiacent cell value (col. B), that coresponding to the max value in col. C
in this case i want to return 3489655 (cell A2).
i can only get the max for John with formula
Please help me.
I have a workbook with multiple sheets.
in the sheet1 i must return the value from the sheet by the folowing criteria>
suppose o sheet1 i select name 'John', and from the sheet2 that has the structure, i must return the addiacent cell value (col. B), that coresponding to the max value in col. C
Book1.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | John | 3489655 | 3 | ||
2 | Mary | 792416,6 | 1 | ||
3 | John | 860903,6 | 2 | ||
4 | Mary | 901028,9 | 2 | ||
5 | Mary | 2923,57 | 3 | ||
6 | John | 3197,57 | 1 | ||
Sheet2 |
in this case i want to return 3489655 (cell A2).
i can only get the max for John with formula
Excel Formula:
=SUMPRODUCT(MAX(((Sheet2!A:A=A1) * (Sheet2!C:C))))
Please help me.
3489655 |