Help with forumula in macro

Hi, I need help in with writing a formula that I can put in a macro. I have attached the worksheet for your viewing. I would like to have the formula look in column A and find 2D-1st then in column G put the calculation of the owner column. Each sheet that I will using will have different row numbers each time it looks for 2D-1st, For example on this worksheet the 2D-1st is A:13, the cell that I want it to put the calculation will be in G:13, H13 and I:13. Then another sheet may have the 2D-1st in A:20 and I will need the calculations to be in G:20,H:20 and I:20. The calculations that I will be using is at the top of the sheet. Owner/Stallion and Breeder. Is it possible to find 2D-1st in column A and return the calculations in the same row? Thank you for your help.