I've tried figuring this out with formulas but I think I need a vba
solution.
I've got a column with values in column A in sheet 1 and I've got a
column of values in column G of sheet 2. Every value in column G sheet2
is one of the values from column A sheet 1. What I need is something
that will compare G to the whole column of A and then copy the value
from cell B from sheet 1 to Column H in sheet 2.
Example:

Sheet 1 Sheet 2
A B G H
1 1 1
2 8 1
3 4 2
4 6 4
5 3 4
4
5

Would become

Sheet 2
G H
1 1
1 1
2 8
4 6
4 6
4 6
5 3

Any help would be appreciated.