I hope I am saying this correctly. I am trying to create a formula that would
give me the following result in cell A1. If the value in cell A2 is equal to
horse return the value in A4, if not return will be blank.

I want to sincerely thank in advance anyone who helps this novice user out.