Need to lookup highest value by vlookup

[Ravindu94]

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 chart from second chart. here attached the details. any one have an idea to sort my issue

[#2]

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

[#3]

thank you. its working properly