I have this problem...

[dalipsinghbisht]

What should i do when i have to work in an Excel File and there are man
Account no in Sheet 1 and Sheet 2 contains many account no and ther
Date now i have to take Account no. from sheet 1 one by one and come t
the Sheet 2 to search there availability and paste there Date in Shee
1.

i.e.

sheet 1 contains a column
Coulmn A
Account No.
0004317575603512196
0004006676010767385
0004317575603323636
0004317575603277113
0004317575603539660.

Sheet 2

Coulmn A
Account No.
0004317575603631103
0004317575603578569
0004317575603097701
0004317575603512196
0004006661130015717
0004006676010767385
0004317575603548794
0004317575603323636
0004006661030774793
0004317575603277113
0004317575603539660

Sheet 2

Coulmn B
Date
01/30/06
01/30/06
01/30/06
01/30/06
01/27/06
01/30/06
01/05/06
01/31/06
01/18/06




Is there any way that we can paste all 5 Account No's Date to the fron
of Account Nos in Sheet 1


Note: i use =vlookup(A2,sheet2!a2:b8439,2,0) but it is not workin
properly cuz it is not taking all the dates in sheet 1.

Thanks in advanc

 

[Guest]

VLOOKUP(A17,sheet2!$A$2:$B$10,2) can do the job

“dalipsinghbishtâ€ç¼–写：

 

[Guest]

If Topper's answer was not helpful, then your question is not clear. Instead
of reposting the same question, reply back in your earlier thread explaining
why the proposed answer was inadequate.

Jerry

 

[dalipsinghbisht]

Still Its not working properly... ok the you try i am giving you th
link for the file

Here is the link...

http://www.geocities.com/dalipsinghbisht/tryit.zi