# 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

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

#### 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

##### Active Member
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
393
Replies
5
Views
505

1,170,942
Messages
5,872,857
Members
432,950
Latest member
ALeXceLBr

### 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