?Offset and formulatext functions?

[AllMikeLong]

Hi,

I'm having trouble figuring out how to get excel to work with me here. I have attached an example workbook showing what I'm trying to do. If someone could explain to me how to solve this I would be very thankful.

I'm trying to construct a summary table of a large worksheet. I have a value (given in cell G4). Now my summary table begins at cell J7 with a copy of the value in G4. ok easy (this part i have to manually select for each of the data subsets due to slight varaition in entries to each subset). Next in under "result 1" (cell K7) I have used formulatext and RIGHT functions to extract the text cell information from the original location of my date value. In "result2" (cell L7) I have used offset function to pull data from a cell (E7) near to the original location of my date value. Now what I can't seem to figure out is using both offset and formulatext (as well as RIGHT) to pull data from cell (E7). "Result3" show what I've been trying to use, but excel keeps telling me that the formula is incorrect. What am I missing here?

Thank you,

-Michael

P.S. if you don't see my attachment, it's because I haven't figured out how to attached anything yet.

 

[gaz_chops]

Welcome to the forum, see my signature for how to attach an example.