# 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

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### 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,569
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.

### Which adblocker are you using?

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