can any one help

[dalipsinghbisht]

What should i do when i have to work in two Excel File and there ar
many Account no in Workbook 1 and book 2 contains many account no an
there amount now i have to take Account no. from book 1 one by one an
come to the book 2 to search there availability and paste there amoun
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 th
front of Account Nos in Book 1

Thanks in advanc

 

[Guest]

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