software

What should i do when i have to work in an Excel File and there are many
Account no in Sheet 1 and Sheet 2 contains many account no and there
Date now i have to take Account no. from sheet 1 one by one and come to
the Sheet 2 to search there availability and paste there Date in Sheet
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 front
of Account Nos in Sheet 1Note: i use =vlookup(A2,sheet2!a2:b8439,2,0) but it is not working
properly cuz it is not taking all the dates in sheet 1.

Thanks in advance--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile: www.excelforum.com/member.php...oamp;userid=32557
View this thread: www.excelforum.com/showthread...hreadid=524720
VLOOKUP(A17,sheet2!$A$2:$B$10,2) can do the job

“dalipsinghbisht”编写：

gt;
gt; What should i do when i have to work in an Excel File and there are many
gt; Account no in Sheet 1 and Sheet 2 contains many account no and there
gt; Date now i have to take Account no. from sheet 1 one by one and come to
gt; the Sheet 2 to search there availability and paste there Date in Sheet
gt; 1.
gt;
gt; i.e.
gt;
gt; sheet 1 contains a column
gt; Coulmn A
gt; Account No.
gt; 0004317575603512196
gt; 0004006676010767385
gt; 0004317575603323636
gt; 0004317575603277113
gt; 0004317575603539660.
gt;
gt; Sheet 2
gt;
gt; Coulmn A
gt; Account No.
gt; 0004317575603631103
gt; 0004317575603578569
gt; 0004317575603097701
gt; 0004317575603512196
gt; 0004006661130015717
gt; 0004006676010767385
gt; 0004317575603548794
gt; 0004317575603323636
gt; 0004006661030774793
gt; 0004317575603277113
gt; 0004317575603539660
gt;
gt; Sheet 2
gt;
gt; Coulmn B
gt; Date
gt; 01/30/06
gt; 01/30/06
gt; 01/30/06
gt; 01/30/06
gt; 01/27/06
gt; 01/30/06
gt; 01/05/06
gt; 01/31/06
gt; 01/18/06
gt;
gt;
gt;
gt;
gt; Is there any way that we can paste all 5 Account No's Date to the front
gt; of Account Nos in Sheet 1
gt;
gt;
gt; Note: i use =vlookup(A2,sheet2!a2:b8439,2,0) but it is not working
gt; properly cuz it is not taking all the dates in sheet 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=524720
gt;
gt;

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

quot;dalipsinghbishtquot; wrote:

gt;
gt; What should i do when i have to work in an Excel File and there are many
gt; Account no in Sheet 1 and Sheet 2 contains many account no and there
gt; Date now i have to take Account no. from sheet 1 one by one and come to
gt; the Sheet 2 to search there availability and paste there Date in Sheet
gt; 1.
gt;
gt; i.e.
gt;
gt; sheet 1 contains a column
gt; Coulmn A
gt; Account No.
gt; 0004317575603512196
gt; 0004006676010767385
gt; 0004317575603323636
gt; 0004317575603277113
gt; 0004317575603539660.
gt;
gt; Sheet 2
gt;
gt; Coulmn A
gt; Account No.
gt; 0004317575603631103
gt; 0004317575603578569
gt; 0004317575603097701
gt; 0004317575603512196
gt; 0004006661130015717
gt; 0004006676010767385
gt; 0004317575603548794
gt; 0004317575603323636
gt; 0004006661030774793
gt; 0004317575603277113
gt; 0004317575603539660
gt;
gt; Sheet 2
gt;
gt; Coulmn B
gt; Date
gt; 01/30/06
gt; 01/30/06
gt; 01/30/06
gt; 01/30/06
gt; 01/27/06
gt; 01/30/06
gt; 01/05/06
gt; 01/31/06
gt; 01/18/06
gt;
gt;
gt;
gt;
gt; Is there any way that we can paste all 5 Account No's Date to the front
gt; of Account Nos in Sheet 1
gt;
gt;
gt; Note: i use =vlookup(A2,sheet2!a2:b8439,2,0) but it is not working
gt; properly cuz it is not taking all the dates in sheet 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=524720
gt;
gt;


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

Here is the link...

www.geocities.com/dalipsinghbisht/tryit.zip--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile: www.excelforum.com/member.php...oamp;userid=32557
View this thread: www.excelforum.com/showthread...hreadid=524720