Image of the excel file is above/attached.
I have data in Column
D that are matching in Column
What I need is for Column
C to output the value in Column
B same row
So in an essence:
D2 has a value
D2 value in Column
A and then copy value from column
B same row.
So The data in Col A & B are from one source. (Website order records)
The data from Col D are from another source. (Order Shipping processing software).
The problem I ran into is that the OSP is reporting to the site the incorrect shipdate.
So to correctly adjust the info, I have to find & match the order number in Col D from Col A then write the info from Col B to Col C (corresponding cell).
Then after all of that, force it back into SQL DB in the OSP.
**The problems comes in threes
- Some of the matches does not match whole case.
Somehow, I am getting a match for those two, when in fact it is not. 2. When it does find the exact match, it doesn't write the value of the cell that is adjacent to it. 3. Col A have 1422 entries, Col D have 2563 entries. Where did all the extras come from ?
See, my problem is a convoluted one, If item 1&2 are resolved, then I can figure out the most critical one (item 3)
I hope that clarifies the lost in oblivion panic at 3am.