moving a cell reference down one row automatically

Please see attached.

Thank you so much!!!! I knew there had to be a way. I researched it and had a feeling it was a LOOKUP function, but I have only used LOOKUP in one column or one row. I wasn't sure how to use it for an entire table. You have saved me so much work. :D