Search Columns from Multiple Sheets If Match Populate Value from 1 of the sheets

I have 2 sheets in a workbook that look like the example attached. I want to compare the data in column A of each sheet so that if there is a match of county names then column C in sheet 1 is populated with the data for that county from Column B from sheet 2.

The Counties are not in perfectly matching order and sheet 2 is missing a county.

This is an extremely poor explanation. But basically I will end up with sheets with housing data for 5 years, 1 year on each sheet. I want to parse those together by county so I can look at the change for each county over the 5 year period. Problem is some of the years are missing data for some of the counties, so I can't just copy and paste.

Thanks so much in advance!]

Hi, welcome to the forum

If I understand you correctly, this should do what you want....
C2=IFERROR(VLOOKUP($A2,'2012'!$A$2:$B$1847,2,0),"Not Found")
copied down

Then copy that to each new column and change the year ref...'2012'! to '2011'! etc and copy that down

You could also use this instead, and you wont need to change the years, but it could become resource-intense and slow you down...
C2=IFERROR(VLOOKUP($A2,INDIRECT("'"&LEFT(D$1,4)&"'!$A$2:$B$1847"),2,0),"Not Found")
copied down and across as needed

Glad it worked for you and thanks for the feedback