This may be a fairly easyone but basically i need a formula to look to see if
a specific cell value is in a vertical list of values on another spreadsheet
(hence why i thought maybe a vlookup?), if it is i want it to sum a set
number of the neighbouring horitontal cells, although the numbers of coloumns
i want it to sum will vary each month as i move through the year (ie finding
the YTD value), but always staying within the same row.

I have tried a variety of vlookups and/or sumif combinations but just can
get it to work, so i would be grateful if anyone can help...........