|
I have this problem...
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 |
I have this problem...
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 |
I have this problem...
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" wrote: 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 |
I have this problem...
Still Its not working properly... ok the you try i am giving you the link for the file Here is the link... http://www.geocities.com/dalipsinghbisht/tryit.zip -- dalipsinghbisht ------------------------------------------------------------------------ dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557 View this thread: http://www.excelforum.com/showthread...hreadid=524720 |
| All times are GMT +1. The time now is 02:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com