Excel: Can't Find Summed Value 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))

A B C D
1 Thrower Throw 1 Throw 2 Throw 3
2 Daniel 45.99 23.78 51.02
3 Richard 40.22 42.32 43.69
4 Matt 37.55 34.2 31.5
5 Stevie 69.43 0 56.11
[CENTER] [/CENTER]


This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of April 11, 2018.


For more resources for Microsoft Excel