Forum Discussion

Ravindu94's avatar
Ravindu94
Brass Contributor
Apr 29, 2019

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

admin
Formulas and Functions

2 Replies

  • Shivang_Sharma's avatar
    Shivang_Sharma
    Copper Contributor
    Apr 29, 2019

    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.

     

    ProductHighest Value    
    product14432=MAXIFS($B$4:$B$24,$A$4:$A$24,$G10)
    Product27102    
    Product37632    

     

    ProductHighest Value 
    product14432=SUMPRODUCT(MAX(($A$4:$A$24=$G4)*($B$4:$B$24)))
    Product27102 
    Product37632 

     and please find the workbook attachment.

     

    Regards

    Shivang

Resources