Hi,
I'm trying to create a formula that would give the same result as on Sheet2 in the example workbook. eg, take the name in Column A/Sheet 2, and look on Sheet1 using Date of Birth to state if she has given birth in the Year stated in Row1/Sheet2.
If she has not, I would like 0 returned, if 1 return 1 and if 2 in the same year, return 2. As is currently shown on Sheet2
Do not worry about the colour format, I can do that.
Thanks very much in anticipation.
Regards
Bookmarks