I have two columns of codes - Column A has 10400 codes with prices that go to
that specific code in Column B. Then I have Column C which has a selection of
1400 of those codes from Column A. Is there a way that I can take the Column
C codes and compare them to those in Column A and if there is a match put
just those that match on a different on a different worksheet - giving me a
new list of those 1400 codes with the correlating prices?

Example:
A B C
0400T 275.00 0500T
0500T 6.50 24900
12000 44.00 66000
24900 339.00 H0876
66000 112.00
99823 10.00
H0876 13.85

After run would have:
A B
0500T 6.50
24900 339.00
66000 112.00
H0876 13.85