bencar
Banned user
- Joined
- Jun 8, 2016
- Messages
- 149
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))
<tbody>
</tbody>
=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 |
<tbody>
</tbody>
Last edited: