justinf10000
New Member
- Joined
- Feb 24, 2016
- Messages
- 2
It sounds a bit confusing so please let me explain.
I have 2 columns:
Column A is a serial number
Column B is blank (but i want it to contain a part number)
Then I have 2 more columns
Column C is a serial number
Column D is the corresponding part number to the serial number in column C.
I need to get the correct part number into column B. So basically i need excel to run logic to check which cell from Column C is equal to column A and then insert the correct cell data from column D into column B.
How do i do this? I'm not that good with excel.
I would appreciate any help. Also if this cannot be done with excel, I can use access instead but i'm not sure how to do it there either.
Thank you!!
I have 2 columns:
Column A is a serial number
Column B is blank (but i want it to contain a part number)
Then I have 2 more columns
Column C is a serial number
Column D is the corresponding part number to the serial number in column C.
I need to get the correct part number into column B. So basically i need excel to run logic to check which cell from Column C is equal to column A and then insert the correct cell data from column D into column B.
How do i do this? I'm not that good with excel.
I would appreciate any help. Also if this cannot be done with excel, I can use access instead but i'm not sure how to do it there either.
Thank you!!