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
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies