Hi Spencer,

Thanks a lot for your reply. I did try both the formula and it is giving me a #NAME? error. I am using excel 2003 and do not have analysis tool pack


To give u a bigger picture of the problem

I have two data validation lists one for 2011 (Jan-11, Feb-11, Mar-12, Apr-11)
and second data validation list 2012 (Jan-12, Feb-12, Mar-12, Apr-12)

I do not intend to use both data validation lists . I prefer to use only one data validation list, that is, 2011 . Corresponding month for 2012 should automatically come up when i select the month feom 2011 data validation drop down.

Hope this will further define the problem.

Thanks Spencer. Awaiting ur reply.