SUM VLOOKUP Col No.s in array fixed to variable

In the formula ={SUM(VLOOKUP($A$808,Input!$807:$1069, {4,6,8,10,12,14,16},FALSE))} (which works) is it possible to replace the fixed col No.s with cell references. The referenced cells contain valid Col No.s which will change over time. The columns are not contiguous - that would be too easy.

The revised fornula would look something like:

={SUM(VLOOKUP($A$808,Input!$807:$1069,
{Input!D$2,Input!F$2,Input!H$2,Input!J$2,Input!L$2,Input!N$2,Input!P$2},FALSE))}

which doesn't work. Can someone point me in the right direction?

Originally Posted by :) Sixthsense :)

Try this...

First indications are that it does the job exactly as I would wish. It will take some time for me to fully test but thanks very much for your help.

I'll add "resolved" and rep in due course.