Forum Discussion
Need to lookup highest value by vlookup
i have detail chart with my product details. every product repeat at one table with different kind of values. there is another table without duplicates. i need to get highest value from that first ch...
Hii Ravindu94,
I have solve your issue
but you are using Miscrosoft Office 365/2019 Then use MAXIFS funcation
other your query solve with Sumproduct.
| Product | Highest Value | ||||
| product1 | 4432 | =MAXIFS($B$4:$B$24,$A$4:$A$24,$G10) | |||
| Product2 | 7102 | ||||
| Product3 | 7632 |
| Product | Highest Value | |
| product1 | 4432 | =SUMPRODUCT(MAX(($A$4:$A$24=$G4)*($B$4:$B$24))) |
| Product2 | 7102 | |
| Product3 | 7632 |
and please find the workbook attachment.
Regards
Shivang
- thank you. its working properly
