Can't Find Summed Value of 2 Largest Numbers in Vlookup

bencar

Banned user
I'm trying to use vlookup to lookup a value that sums up the 2 largest numbers in columns B,C and D. I tried these 2 formulas on my own but thet dont work. I also tried using them as array functions. But still doesnt work. How can I make this work?

=sum(VLOOKUP(E9,A2:D5,{LARGE(B2:D2,{1,2})},0))
=sum(VLOOKUP(E9,A2:D5,(LARGE(B2:D2,{1,2}),0))

ABCD
1ThrowerThrow 1Throw 2Throw 3
2Daniel45.9923.7851.02
3Richard40.2242.3243.69
4Matt37.5534.231.5
5Stevie69.43056.11

<tbody>
</tbody>

Last edited:

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

AlanY

Well-known Member
try

Code:
``=LARGE(INDEX(\$B\$2:\$D\$5,MATCH(E9,\$A\$2:\$A\$5,0),),1)+LARGE(INDEX(\$B\$2:\$D\$5,MATCH(E9,\$A\$2:\$A\$5,0),),2)``

or

Code:
``=SUM(LARGE(INDEX(\$B\$2:\$D\$5,MATCH(E9,\$A\$2:\$A\$5,0),),{1,2}))``

confirm with shift-control-enter

Last edited:

bencar

Banned user
try

Code:
``=LARGE(INDEX(\$B\$2:\$D\$5,MATCH(E9,\$A\$2:\$A\$5,0),),1)+LARGE(INDEX(\$B\$2:\$D\$5,MATCH(E9,\$A\$2:\$A\$5,0),),2)``

or

Code:
``=SUM(LARGE(INDEX(\$B\$2:\$D\$5,MATCH(E9,\$A\$2:\$A\$5,0),),{1,2}))``

confirm with shift-control-enter

Thats not it. I need to use vlookup.

bencar

Banned user

Come on dude.. this isnt high school stuff I'm asking. Get serious

bencar

Banned user
Any way to use LARGE in VLOOKUP?

bencar

Banned user

How Do I Find Summed Values of 2 Largest Numbers in Vlookup

I'm trying to use vlookup to lookup a value that sums up the 2 largest numbers in columns B,C and D. I tried these 2 formulas on my own but thet dont work. I also tried using them as array functions. But still doesnt work. How can I make this work??

=sum(VLOOKUP(E9,A2:D5,{LARGE(B2:D2,{1,2})},0))
=sum(VLOOKUP(E9,A2:D5,(LARGE(B2:D2,{1,2}),0))

ABCD
1ThrowerThrow 1Throw 2Throw 3
2Daniel45.9923.7851.02
3Richard40.2242.3243.69
4Matt37.5534.231.5
5Stevie69.43056.11

</tbody>
Sheet1

ebea

Board Regular
Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

What is it for a value you lookup in E9? For the sum of the two largest: =SUMPRODUCT(LARGE(B2:D2;{1;2}))

Marcelo Branco

MrExcel MVP
Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

Maybe something like this

 A​ B​ C​ D​ E​ F​ G​ 1​ Thrower​ Throw 1​ Throw 2​ Throw 3​ Thrower​ Result​ 2​ Daniel​ 45,99​ 23,78​ 51,02​ Daniel​ 97,01​ 3​ Richard​ 40,22​ 42,32​ 43,69​ Matt​ 71,75​ 4​ Matt​ 37,55​ 34,2​ 31,5​ 5​ Stevie​ 69,43​ 0​ 56,11​

Formula in G2 copied down
=SUMPRODUCT(LARGE(INDEX(B\$2:D\$5,MATCH(F2,A\$2:A\$5,0),0),{1;2}))

M.

Fluff

MrExcel MVP, Moderator
Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

@bencar
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.

Replies
1
Views
337
Replies
5
Views
336

1,141,298
Messages
5,705,567
Members
421,399
Latest member
hjweiss00

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back