Hi Ben,
How about VLookup? Something like this should work:
VLookup(I2, $J$2:$J$8000, 1, False)
You need to insert this in a separate column. I assumed that Item_I is
in column I and starts at index 2 (therefore I2). Also, you may have to
adjust 8000 to whatever the actual number of rows is. Insert it in any
column in row 2 , and drag it down to the last row. If there is a
match, VLookup will return the Comcode, or else #N/A.
Hope that helps.
Steve
www.stkomp.com
Ben wrote:
LOC_I ITEM_I COMCODE ONHAND_Q PRIM_WH_SEC_C $$ on Hand REEL
223 100047018 100047018 360 1C07E1 280.8 N
223 100050442 100202928 76 1B31C1 82.08 N
223 100202928 100203272 8 1B08C2 28.48 N
223 100203272 100414770 143 1B25F1 180.18 N
223 100203348 100959279 553 1A06D1 474.7 N
086 100203363 100959899 4 P024B3 10.2 N
What I need it to look like is this...
LOC_I ITEM_I COMCODE ONHAND_Q PRIM_WH_SEC_C $$ on Hand REEL
223 100047018 100047018 360 1C07E1 280.8 N
223 100202928 100202928 76 1B31C1 82.08 N
223 100203272 100203272 8 1B08C2 28.48 N
I can do it individually, but there are 4000 comcodes that I have to match,
and I do not have that kind of time with this project. Essentially I need
the Comcode column to match to the Item_I column, however, some will not have
matches. I also neeed the other data to stay locked in place with respect to
the Item_I column. Sorry it is not that clear, it is rather complicated and
it is hard for me to explain.
"Kevryl" wrote:
You have me quite puzzled. Are we talking about a row sort or not? Perhaps
"before" and "after" sample shots would help your explanation.
"Ben" wrote:
Okay, I have 2 columns containing a lot of the same data, but they alos have
different data. Essentially I am trying to match up the ones that match, and
have a record somewhere else in the sheet of the ones that did not have
partners, and what columns they were from. Here is an example.
LOC_I ITEM_I COMCODE ONHAND_Q PRIM_WH_SEC_C $$ on Hand REEL
223 100047018 100047018 360 1C07E1 280.8 N
223 100050442 100202928 76 1B31C1 82.08 N
223 100202928 100203272 8 1B08C2 28.48 N
223 100203272 100414770 143 1B25F1 180.18 N
223 100203348 100959279 553 1A06D1 474.7 N
086 100203363 100959899 4 P024B3 10.2 N
Now I need columns B and C to match up the ones that are the same, without
chaning the data in the rest. Column 'C' can move, but all the others must
stay the same. Any suggestions.