Adding up the contents of a Vlookup table

Hi SHG and davesexcel

Many thanks for your replies, i like both of them,

Thanks

BPJONES

Welcome to the forum.

=SUM(IF(ISNUMBER(M2:M7), M2:M7)) confirmed with Ctrl+Shift+Enter

You can also remove vlookup error with this formula

=IF(ISERROR(VLOOKUP(E3,$B$3:$C$11,2,FALSE)),"",VLOOKUP(E3,$B$3:$C$11,2,FALSE))

If an error occurs, it will display a blank

Replace with your own vlookup formula