Hi,

Is there any way of summing values based on a lookup?

i.e. =sum(vlookup(a1,table,2):vlookup(a1,table,4)

This formula does not work, i want to sum the the values from cell 2 to 4, in the table, hence trying to sum '=sum(a2:a4)' from my table

Please let me know if you need more clarity around this, and many thanks.