How do I match data from two tabs then pull data from one sheet to the other?

I have two tabs that are similar, just with updated information from each quarter. I am looking up the unique identifier in column C in tab 1 to match to the previous quarter in tab 2. If there is a ...