can any one help
 

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

can any one help
 

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