I have two sheets... Cdata & summary

Cdata has fields like

A1: Apr 05
A2: May05
A3: June 05
and so on


Summary sheet. A20. currentregion keep changing at click of option boxes.
but
The formula needs to lookup a20.region

If first row contains 04/05 as heading
then copy last cell in that row ( grand total at bottom row)
and paste into Cdta in Apr 05

and so with 05/05, etc

also, if data is not found... in sumamry sheet then value in cdata should be
cleared

blank

Is it possible by vlookup or macro?


vlookup would be ideal as a chart picks up data from the cdata sheet

I have lookup from any possible formats in my workbooks, and a a graph
that updates with any lookups, but I need you to be a bit more specific
to help


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=490120