Match , copy paste (using find?)

[Carlos]

Hi,

Basically what I have is two excel sheets. One extensive list of accounts
and one with a selection of accounts from the extensive list.

Sheet 1 has a selected list of account numbers in Col A (about 400). And
nothing in col B

sheet 2 has a total list of account numbers in Col A (about 3000). And data
in col B.

I need to find the accounts on sheet 1 in sheet 2, and copy the data in the
B col of sheet 2 into the b col of sheet 1 for the relative account number.

I'm looking at Selecting A1(a/c number) finding the account number in sheet
2, copy B2 from sheet 2, and pasting back in sheet one in B1, then move onto
A2, until the list is complete.

Can anyone help with this?

Thanks
Carl

 

[Gary''s Student]

Don't use VBA, use VLOOKUP()


In Sheet1, B1 enter:
=VLOOKUP(A1,Sheet2!A$1:B$3000,2) and copy down

 

[Carlos]

Gary,

Thank you very much, So simple yet works a treat.. One for my notebook!!

Cheers
Carl

 

[Carlos]

Is there anyway to amend this so it tells you it's not found what it's
looking for rather then copying the last posted dated?