generallyclueless
New Member
- Joined
- Feb 23, 2005
- Messages
- 2
I have two worksheets, both which contain a column named serial number . Both sheets also contain a column for PO numbers; the first sheet's PO number column is blank while the second sheet's PO number column contains value.
Is there anyway for excel to compare the value in, say, the serial numbers from the second sheet to those in the first and, if it find a match, to pull over the PO number from second worksheet into the PO Number cell of the matched record?
If it would make it easier, I can move the serial number and the PO columns of both worksheets to column A and B, respectively.
Thank you so much in advance! Any help is greatly appreciated!
Is there anyway for excel to compare the value in, say, the serial numbers from the second sheet to those in the first and, if it find a match, to pull over the PO number from second worksheet into the PO Number cell of the matched record?
If it would make it easier, I can move the serial number and the PO columns of both worksheets to column A and B, respectively.
Thank you so much in advance! Any help is greatly appreciated!