software

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 21Is 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: www.excelforum.com/member.php...oamp;userid=32557
View this thread: www.excelforum.com/showthread...hreadid=524696Use the VLOOKUP function.

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

lt;A2gt; Account number on sheet1
lt;A2:b100gt; accounts and amount on Sheet2
lt;2gt; select 2nd value i.e value in column BPut the formula in B2 on sheet1 and copy down

Change columns/ranges to meet your needs

HTH

quot;dalipsinghbishtquot; wrote:

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