There is a trailing space after Franklin in C36 of Country Yields sheet....

and the formula should be:

=VLOOKUP(B$3,'County yields'!$C$4:$AB$101,Sheet2!I14,FALSE)