Tough one

B

Ben

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.
 
K

Kevryl

You have me quite puzzled. Are we talking about a row sort or not? Perhaps
"before" and "after" sample shots would help your explanation.
 
W

wisccal

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
 
Top