Find the text and copy the next column value to sheet 2

[Pratap 1987]

Hi,
I have a workbook with two sheets.

Sheet 1 : -

Column A - Has a list of account numbers with 5 to 9 digits (Maxinum 5 account numbers)

Column B - Has the count of pending items next to the respective account numbers

Sheet 2 : -

Column L - Has the list of five account numbers as below : -
414444 (In L29)
878664 (In L30)
693195777 (In L31)
42322 (In L32)
565991 (In L33)

Column N - Should reflect the count of the respective account number available in Sheet 1. And if the account number is not available in sheet 1 - the count should be reflected as '0' (Zero).

Could some one help me out in getting a Macro for the above requirement.

Thanks,

 

[jrabi]

In sheet 2 column N29 enter:

=COUNTIF(Sheet1!A:A,L29)

And copy down.

 

[Pratap 1987]

Hi,

Thanks for your immediate response.

But, however I did not want the count of the account numbers in Column A (Sheet 1) to be reflected in sheet2.
Instead I want the Value available in the cell (From Column B - Sheet 1) next to the account number to be reflected in Sheet 2 (N Column) corresponding to the account number.

Sorry for not making you clear at the first shot.

Also, it would be great if you could get me a Marco. Because, the workbook is automated with few other macros. And the formula in the cell gets deleted once I run the automated Macro.
Thanks,