Home

Need to lookup highest value by vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-497878%22%20slang%3D%22en-US%22%3ENeed%20to%20lookup%20highest%20value%20by%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-497878%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20detail%20chart%20with%20my%20product%20details.%20every%20product%20repeat%20at%20one%20table%20with%20different%20kind%20of%20values.%20there%20is%20another%20table%20without%20duplicates.%20i%20need%20to%20get%20highest%20value%20from%20that%20first%20chart%20from%20second%20chart.%20here%20attached%20the%20details.%20any%20one%20have%20an%20idea%20to%20sort%20my%20issue%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-497878%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-498415%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20lookup%20highest%20value%20by%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-498415%22%20slang%3D%22en-US%22%3E%3CP%3EHii%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329467%22%20target%3D%22_blank%22%3E%40Ravindu94%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EI%20have%20solve%20your%20issue%3C%2FP%3E%3CP%3E%26nbsp%3B%20but%20you%20are%20using%20Miscrosoft%20Office%20365%2F2019%20Then%20use%20MAXIFS%20funcation%26nbsp%3B%3C%2FP%3E%3CP%3Eother%20your%20query%20solve%20with%20Sumproduct.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EProduct%3C%2FTD%3E%3CTD%3EHighest%20Value%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Eproduct1%3C%2FTD%3E%3CTD%3E4432%3C%2FTD%3E%3CTD%3E%3DMAXIFS(%24B%244%3A%24B%2424%2C%24A%244%3A%24A%2424%2C%24G10)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EProduct2%3C%2FTD%3E%3CTD%3E7102%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EProduct3%3C%2FTD%3E%3CTD%3E7632%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EProduct%3C%2FTD%3E%3CTD%3EHighest%20Value%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Eproduct1%3C%2FTD%3E%3CTD%3E4432%3C%2FTD%3E%3CTD%3E%3DSUMPRODUCT(MAX((%24A%244%3A%24A%2424%3D%24G4)*(%24B%244%3A%24B%2424)))%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EProduct2%3C%2FTD%3E%3CTD%3E7102%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EProduct3%3C%2FTD%3E%3CTD%3E7632%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3Band%20please%20find%20the%20workbook%20attachment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EShivang%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-502967%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20lookup%20highest%20value%20by%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-502967%22%20slang%3D%22en-US%22%3Ethank%20you.%20its%20working%20properly%3C%2FLINGO-BODY%3E
Ravindu94
Contributor

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 Replies

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

thank you. its working properly