I have values in column A and B on another tab in my worksheet. On a
separate tab, I have other values in Column A. I want a formula that looks
at Cell A1, Sheet 1 and matches it to the same value in Column A, sheet 2 and
enters the value that is next to the matching value in column b, sheet 2.

Any suggestions?