Find a number in Column A matching Column B & move # in C matching Column B

Find a number in column A that matches a number in column B. Take the number in column C next to the matching number in B and post it in column E on the same line as the number in column A

JudeH,

Welcome to the forum. What you're looking for is a VLOOKUP formula. Attached is a sample workbook showing how it works based on criteria you described. In cell E2 is the following formula:
=VLOOKUP(A2,B:C,2,FALSE)

And then copied down.

Hope that helps,
~tigeravatar