Vlookup multiple values in a range and sum

Hi all,
i've looked around and havent been able to solve this problem so far, maybe you guys can help.
i have a set of data in which i'm trying to lookup a value from a range of file #'s (ex 100-125) that i have concatenated with a file ID (ex 123456789). as of right now i have to vlookup each individual concatenated number, return the result value in its own column (one for 100, one for 101 and so on..) and then sum all 25 columns to get the final number) is there a way to vlookup the range (ID+100:125) and sum the results?

here's the formula i use for each column starting with 100, A2 representing the file ID, C:O being the array

=IF(ISERROR(VLOOKUP(A2&100,$C$2:$O$10000,13,FALSE)),"0.00",VLOOKUP(A2&100,$C$2:$O$10000,13,FALSE))

any help or direction is much appreciated!

hm that didnt seem to work. the E:E should be switched to C:C also (column e is concatenated for a different set of values which i'll apply to whatever the solution is and it has an extra 0) i would hope it some complicated string i've also tried =IF(ISERROR(VLOOKUP(A2&{1501,1502,1503,1504}$C$2:$O$9803,13,FALSE)),"0.00",VLOOKUP(A2&{1501,1502,1503,1504},$C$2:$O$9803,13,FALSE))

it looks like its adding other File#'s just want it to capture from a range of say 1501-1525. its capturing everything associated with that ID below 1501 want to exclude everything below that. its close though.

that works for 1501 because P1 is labeled as such, what about file #'s 1502-1525 how do i include them in the sum?

whoops sorry for the confusion. thats just showing you what i have now. my end result is to have all files #'s 1501-1525 sum in one cell based on a vlookup of the concatenated #. so imagine instead of 1501,1502,1503 columns etc just one column called 1500 series with the end sum calculated in one cell.

yes, thats exactly what im attempting to do!

yes, that's it! well add $ to B & O, but you nailed it. thanks man!