VLOOKUP(A17,sheet2!$A$2:$B$10,2) can do the job
€œdalipsinghbisht€ç¼–写：
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 1
Note: 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: http://www.excelforum.com/member.php...o&userid=32557
View this thread: http://www.excelforum.com/showthread...hreadid=524720