What data do you want to retrieve? You could use HLOOKUP with a MONTH
function on A1 for this, or an INDEX/MATCH combination , but you will need
to give more information about how your data is laid out and what you want
to do with it if you need a more specific formula.

Hope this helps.

Pete

"KT" wrote in message
...
Hi,

I have a date in sheet one cell A1. In sheet two I have monthly data. Now
If
the date is 30/6/2008 I want data from June collumn and so on. Hope I\m
making sence here. Cannot use IF since there is at least 12 collumns of
data.

Any suggestions?