I am putting a level scheduling spreadsheet together, where I want to slide schedule hours left and right on the row. At the top are the dates. So I want to see where the first occurrence of hours occur in a row (project start), and then look at the date in that column at the top of the page, then put that date in a cell on another page. I also want to look at the last occurrence of hours in a row and look at the date at the top of that column (project End).
With HLookup, I can find a date at the top of the page, and then look at the value in another row, but I can't go the other way. Any ideas?