I am using VLOOKUP as part of a SUM array formula like this:

{=SUM(VLOOKUP(A9:A10,COLORTABLE,2,FALSE))}

I was expecting that this would lookup the value associated with A9
and SUM it with the value associated with A10. That is my
understanding of how array formulas work.

This is not the case - instead, the value returned by the array SUM is
the single value associated with A9 and there is no array processing
going on.

Can someone confirm if VLOOKUP is not capable of working with array
formulas?

Thanks