An easy way sis to add a new column and then use vlookup. the following
formula is used in column 3. Put formula in C3 and then copy down the column.

=IF(VLOOKUP(A1,A$1:B$9,2,FALSE)0,A1,"")

196618 196650 196618
196625
196650
196663 196663 196663
196669
196686 196686 196686
196694 196694 196694
196699 196699 196699
196711


"Nigel" wrote:

I guess one of the pieces of information that is missing before a solution
could be suggested is how is new data being loaded? Is the entire worksheet
being replaced or are new data being appended?

Will the 2nd column always have a matching partner in 1st column, if not
what do you want to do with any orphan records, also could there be
duplicates in 1st, 2nd or both columns?


--

Regards,
Nigel




"scott" wrote in message
...
I'm trying to think of a way to "sort" or "match" two columns of cells
based
on if the values of the rows are equal. For examle, LISTING 1 below shows
cell B2 equal to 196650. I need a way with code to "sort" or "match" that
value with it's equal in column A. So my results would end up looking like
LISTING 2 below, where the 196650 value gets moved to cell B4.

These are bill of laiding codes that will come in each day, so column A's
values would always be increasing as well as column B's billed numbers
would (i.e. cells would be shifting down).

Can someone suggest any functions that may exist that could take the value
of a cell and match it to the correct cell like I described below? I'm
mainly an Access database programmer, but have done a few Excel apps
before,
but I just can't get a game plan in my mind on how to come up with a
solution for this problem. Any advice or guidance would be appreciated.


LISTING 1:

BOL BOL Billed
196618 196650
196625
196650
196663 196663
196669
196686 196686
196694 196694
196699 196699
196711

LISTING 2:

BOL BOL Billed
196618
196625
196650 196650
196663 196663
196669
196686 196686
196694 196694
196699 196699
196711