Filtering column from 1 worksheet into another

[selsley]

Hi.
I have Excel 2003.
I've got 2 worksheets: 1 with column A full of account numbers and column B with data in some of the rows.
I've got a second worksheet with some of the same account numbers and no data in column B.
I need to copy the notes in column B from worksheet 1 to column B of the relevant account numbers in worksheet 2. Is there a program that will do this?
Thanks
Steve (Cheltenham UK)

[VBA Noob]

Hi,

Try a vlookup. The attached explains more

http://www.contextures.com/xlFunctions02.html

VBA Noob