The Sum of a range of VLookup Values

[sammon]

Hi,

I have a row that contains a range of values. I want to find the total of the results of these values once i've put them through a VLookup.

Example:

My values go from F2 through to V2. The table which I will use for the VLookup is A35 to B43. I know I could do it by doing;

=(VLOOKUP(F3,$A$35:$B$47,2,FALSE))+(VLOOKUP(G3,$A$35:$B$47,2,FALSE))+(VLOOKUP(H3,$A$35:$B$47,2,FALSE))+(VLOOKUP(I3,$A$35:$B$47,2,FALSE))etc... but I am hoping there is a quicker way to do it.

Thanks.