Vlookup / sumif (maybe....) query....

[Heidi]

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...........

 

[Bernie Deitrick]

Heidei,

The general idea of the equation would be along the lines of

=SUM(OFFSET(SheetName!$1:$65536,MATCH("Specific Value",SheetName!$A:$A,FALSE)-1,1,1,MONTH(TODAY())))

Not sure when you say spreadsheet whether you mean a different sheet within the file, or a different
file.

HTH,
Bernie
MS Excel MVP