Something tells me this is going to be easier to resolve than describing the
problem.

I have a column of data and then another column showing the frequencies of
the numbers within that column:

C3:C85 looks like:
14
4
14
22
9
5
(and so forth; basically random with some duplicates)

EA3:EA85 looks like (these are frequencies of column C):
8
5
8
2
7
7
(and so forth)

What I'd like to do is have a separate sheet where I have a column
(Sheet2!A) of the range of numbers in column C (i.e. 1,2,3,4...55, the end of
the range), and then an adjacent column (Sheet2!B) that reports the
corresponding frequency. So:

Sheet2!A Sheet2!B
1 (whatever is in EA)
2 (whatever is in EA)
3 (whatever is in EA)
4 (whatever is in EA)
5 7
(and so forth)

Although there are duplicate numbers in column C, the frequencies, of
course, will always be the same for whatever number is duplicated (so, 5 in C
will always have a freq of 7 as reported in EA).

Any help would be greatly appreciated for the formula that should go into
Sheet2!B that matches Sheet2!A to C and then to EA and then reports whatever
is in EA. It has to be a formula, since the dataset is expanding; I need the
new sheet to update accordingly.

Thank you very, very much in advance.

--Rothman