In my current sheet I have the district names (let names be a,b,c....z etc), Year (2010, 2011), Quarter (1, 2, 3, 4). Quarter is written under the Year, 2010 has quarter 1, 2, 3, 4 under it and same thing for 2011 also.
I have another sheet in the same workbook which has district name, quarter, year and activity
Now, what I wish to do is that
if ((in next sheet if "a" exists under district name column) AND if in that row ("activity" not empty) AND if (Year = 2010) AND if (qtr = 1))
If the above statement is true then in the current sheet against district name "a" under 2010 and under quarter 1 "Yes" should appear otherwise "No". I need to repeat it for other quarters and year 2011 also.
I would really appreciate any help. Thanks in advance!