I am trying to use VLOOKUP to sum multiple values from different columns. I need this because the value is given by name of machine, and in the column directly right of that the cost is given. The table looks like this.
2010 2011
A B C D
M086-1 7000 M105 10000
M105 5000 F120 9200
F120 2500 M086-1 7600
F102 1500 F102 5500

It goes on like this for a list of around 100 machines, and there are about 8 columns.
So i need to sum the values for each machine over these columns.
Say for instance i want to get the total for M105 over these two years, i have been using:

=SUMPRODUCT(VLOOKUP("M105",$A$3:$D$6,{2,4},FALSE))

Then hitting ctrl+shift+enter

This gives me an incorrect value though...

EDIT:

Used SUM and SUMIF to specify machine and that is working much better than previous formula.