RpTheHotrod
New Member
- Joined
- Sep 12, 2008
- Messages
- 14
I have an excel sheet that has the following.
Column A
Item Number
Column B
New Description
Column E
Item Number
Column F
Old Description
Column A and B contains just the items I'm needing. Columns E and F contains the information for an overall project, including things I don't need. An item number is flat out an Item Number. 1 in column A (wherever 1 may be) in reality is also 1 in column E, wherever that 1 may be, as well. The numbers don't match up left to right, though.
ie
1 NewDescription1 3 OldDescription3
3 NewDescription3 1 OldDescription1
5 NewDescription5 6 OldDescription6
6 NewDescription6 2 OldDescription2
2 NewDescription2 5 OldDescription5
*blank*-----------7 OldDescription7
*blank*-----------4 OldDescription4
SO, 1 NewDescription1 ties in with 1 OldDescription1
What I need is a a way to look at the Column A numbers, and find that same number in Column E, and post the Old Description of that number from Column F and put it in Column C.
Any ideas?
End result needs to be
1 NewDescription1 OldDescription1
3 NewDescription3 OldDescription3
5 NewDescription5 OldDescription5
6 NewDescription6 OldDescription6
2 NewDescription2 OldDescription2
In the end...it's a cross reference.
Column A
Item Number
Column B
New Description
Column E
Item Number
Column F
Old Description
Column A and B contains just the items I'm needing. Columns E and F contains the information for an overall project, including things I don't need. An item number is flat out an Item Number. 1 in column A (wherever 1 may be) in reality is also 1 in column E, wherever that 1 may be, as well. The numbers don't match up left to right, though.
ie
1 NewDescription1 3 OldDescription3
3 NewDescription3 1 OldDescription1
5 NewDescription5 6 OldDescription6
6 NewDescription6 2 OldDescription2
2 NewDescription2 5 OldDescription5
*blank*-----------7 OldDescription7
*blank*-----------4 OldDescription4
SO, 1 NewDescription1 ties in with 1 OldDescription1
What I need is a a way to look at the Column A numbers, and find that same number in Column E, and post the Old Description of that number from Column F and put it in Column C.
Any ideas?
End result needs to be
1 NewDescription1 OldDescription1
3 NewDescription3 OldDescription3
5 NewDescription5 OldDescription5
6 NewDescription6 OldDescription6
2 NewDescription2 OldDescription2
In the end...it's a cross reference.
Last edited: