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

<tbody>

</tbody>

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

=sum(VLOOKUP(E9,A2:D5,(LARGE(B2:D2,{1,2}),0))=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: