Formula to Insert data from column D into column B if Column A = Column C

[justinf10000]

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!!

 

[Jonmo1]

WElcome to the board.

In B2 and filled down, put
=VLOOKUP(A2,C:D,2,FALSE)

 

[justinf10000]

Thank you !

 

[Jonmo1]

You're welcome.