Compare string values and automate look-up (multi-step)

Hi,    I have a specific multi-step task I would like to automate in excel, ideally with the use of a formula.    I have four columns (A. application year, B. patent ID, C. backward citations and...