To whom it may concern:
Looking for some help with a problem I've been fighting. My PC runs XP with Excel 2007. I'm trying to use a value from sheet 2 to find all the occurences of that value in column A on sheet 1 and then return multple information back to sheet 2.
My sheet 1 looks something like this:
| OLD |
NEW |
DESC |
| A1 |
AA1 |
ITEM1 |
| A1 |
AA2 |
ITEM2 |
| A2 |
AA3 |
ITEM3 |
| A3 |
AA4 |
ITEM4 |
| A4 |
AA5 |
ITEM5 |
| A4 |
AA6 |
ITEM6 |
| A5 |
AA7 |
ITEM7 |
My sheet 2 looks something like this:
| DELETE KEY |
REF# |
DELETE DATE |
NEW ITEM CODE1 |
NEW ITEM DESC1 |
NEW ITEM CODE2 |
NEW ITEM DESC2 |
| A1 |
1 |
1/1/2010 |
|
|
|
|
| A3 |
2 |
2/1/2010 |
|
|
|
|
I need to use the
"DELETE KEY" column in sheet 2 to find the value in the
"OLD" column in sheet 1 and then return the value in the "
NEW" & "
DESC" columns in sheet 1 to the
"NEW ITEM CODE" & "
NEW ITEM DESC" columns in sheet 2. The problem I have is when there is more than 1 "
OLD" value in sheet 1 that matches my "
DELETE KEY" in sheet 2. If there is only 1 occurrence, I need to return the values to "
NEW ITEM CODE1" & "
NEW ITEM DESC1" respectively, but when there are 2 occurrences the 2nd occurrence needs to end up in "
NEW ITEM CODE2" & "
NEW ITEM DESC2".
So my results should look like this:
| DELETE KEY |
REF# |
DELETE DATE |
NEW ITEM CODE1 |
NEW ITEM DESC1 |
NEW ITEM CODE2 |
NEW ITEM DESC2 |
| A1 |
1 |
1/1/2010 |
AA1 |
ITEM1 |
AA2 |
ITEM2 |
| A3 |
2 |
2/1/2010 |
AA4 |
ITEM4 |
|
|
If anyone has done this in the past I'd appreciate some assistance with it!
laynegray
PS-The simplier the better I'd refer to myself as a casual Excel user. I can get around OK, but I'm not building a rocket ship any time soon:) Thanks again!!