lookup value

[IraAxa]

hi there, i have a table:
Month Target Owner Comments %
May 2011 updated ta not applicable 9700%
May 2011 non reg ol routing availa 15000%
May 2011 trad kl routing not available 10000%
May 2011 part jl not applicable 15000%
May 2011 hgdkl jkl routing availa 25000%
May 2011 hjdk ta routing not available 9900%
june 2011 updated ta not applicable 9700%
june 2011 non reg ol routing availa 15000%
june 2011 trad kl routing not available 10000%
june 2011 part jl not applicable 15000%
june 2011 hgdkl jkl routing availa 25000%
june 2011 hjdk ta routing not available 9900%
July 2011 updated ta not applicable 9700%
July 2011 non reg ol routing availa 15000%
July 2011 trad kl routing not available 10000%
July 2011 part jl not applicable 15000%
July 2011 hgdkl jkl routing availa 25000%
July 2011 hjdk ta routing not available 9900%

and i want to look up for the values, where I'd like to get YTD data and table to looku something like this:

May-11 May-11 Jun-11 Jun-11 Jul-11 Jul-11
Target Owner Comments % Comments % Comments %
updated ta not applicable 9700% not applicable 9700% not applicable 9700%
non reg ol routing availa 15000% routing availa 15000% routing availa 15000%
trad kl routing not available 10000% routing not available 10000% routing not available 10000%
part jl not applicable 15000% not applicable 15000% not applicable 15000%
hgdkl jkl routing availa 25000% routing availa 25000% routing availa 25000%
hjdk ta routing not available 9900% routing not available 9900% routing not available 9900%
meaning, that each month, on the top there will be added column for the comments and %; i used something like, with countif, but it works for the 1st month only; then i try to set the next month -30, it dousnt recognize it, and it copies the data from the previous month. then i tried to copy data on the next sheet and follow the steps, hence again, for example if the month i'm selecting in A1 = June2011, then on the next sheet im'm trying to have =Sheet1A1-30 - which turns to be May2011, hence it still copies the data from June....
I hope it makes sense, and i am in urgent need of help
=IF(ROWS($G$3:$G3)>$H$1,"",INDEX(B$3:B$701,MATCH(ROWS($G$3:$G3),$D$3:$D$701,0)))

[VKS]

Welcome to the Forum IraAxa.
A sample file would help.
Best Regards/VKS

[IraAxa]

test.png
Thanks,

something like this, sorry for the table mess up - didnt know it will come up like that.