Thank you for your response. The above formula works great, but it's not quite what I needed.
Exsample
Year 2013
A B
1 Cow # Calf #
2 0A12 3A12

B2 is what I am trying to populate from a formula. Hope this makes sense