I am looking for a function or combination of functions that can search a column for a cell that contains a specific string (e.g. "January 2007") and return a reference to that cell so that I can use it as the first parameter in an OFFSET() function call.. The data I want to access begins in the row following the one in which the string exists and ends in the row before the one containing the formula invoking the function(s) so I don't see how I can use any of the variations of LOOKUP(). I need a function that will return a cell reference
In effect I am wanting to break up my sheet of financial data into tables that are dynamically defined and named. At the bottom of each month I want to create totals for each column for that month. That involves locating the top of that month's entries and I don't want to have to create the formula manually each month. I plan to use the MONTH() function on the date of the final entry for the month as the first parameter given to the CHOOSE() function to select the month name and concatenate that with the YEAR() function in order to create the search string. Each month has a header displays the month and year generated the same way from the date of the first entry for the month. If there's a better way to accomplish this then please feel free to point out my ignorance and show me how I could accomplish this task more simply. My project is quite small since it relates to financial data for shared household expenses (rent, gas, electricity, phone, water, sewer, trash, Internet, tv, yard, misc.). -- Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
