Im in a HUGE bind here with a report for work. I am looking to combine two reports into one. Basically here is my problem:

Worksheet One:

Column A = File Number
Column B = Line Count

Worksheet Two:

Column A = File Number
Column B = Created By
Column C = Blank (NEEDS TO CONTAIN LINE COUNT)

I need to have a formula (if possible) to lookup File number in Column A in worksheet one and if they match, return the value of Column B from worksheet one to Column C of worksheet two.

Any ideas/Help?