can any one help

[dalipsinghbisht]

What should i do when i have to work in two Excel File and there are many Account no in Workbook 1 and book 2 contains many account no and there amount now i have to take Account no. from book 1 one by one and come to the book 2 to search there availability and paste there amount in book 1.

i.e.

Book 1 contains a column

Account No.
0004317575603512196
0004006676010767385
0004317575603323636
0004317575603277113
0004317575603539660.


Account No. Amount
0004317575603631103 20
0004317575603578569 913
0004317575603097701 712
0004317575603512196 50
0004006661130015717 726
0004006676010767385 10000
0004317575603548794 500
0004317575603323636 200
0004006661030774793 500
0004317575603277113 20
0004317575603539660 21


Is there any way that we can paste all 5 Account No's amount to the front of Account Nos in Book 1

Thanks in advance

[Toppers]

Use the VLOOKUP function.

e.g =Vlookup(A2,Sheet2!A2:B100,2,false)

<A2> Account number on sheet1
<A2:b100> accounts and amount on Sheet2
<2> select 2nd value i.e value in column B


Put the formula in B2 on sheet1 and copy down

Change columns/ranges to meet your needs

HTH

"dalipsinghbisht" wrote:

>
> What should i do when i have to work in two Excel File and there are
> many Account no in Workbook 1 and book 2 contains many account no and
> there amount now i have to take Account no. from book 1 one by one and
> come to the book 2 to search there availability and paste there amount
> in book 1.
>
> i.e.
>
> Book 1 contains a column
>
> Account No.
> 0004317575603512196
> 0004006676010767385
> 0004317575603323636
> 0004317575603277113
> 0004317575603539660.
>
>
> Account No. Amount
> 0004317575603631103 20
> 0004317575603578569 913
> 0004317575603097701 712
> 0004317575603512196 50
> 0004006661130015717 726
> 0004006676010767385 10000
> 0004317575603548794 500
> 0004317575603323636 200
> 0004006661030774793 500
> 0004317575603277113 20
> 0004317575603539660 21
>
>
> Is there any way that we can paste all 5 Account No's amount to the
> front of Account Nos in Book 1
>
> Thanks in advance
>
>
> --
> dalipsinghbisht
> ------------------------------------------------------------------------
> dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557
> View this thread: http://www.excelforum.com/showthread...hreadid=524696
>
>