| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can Vlookup help in that??
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 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=524707 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can Vlookup help in that??
In sheet1 column B2, type following formula, then drag down:
=VLOOKUP(A2,Sheet2!A2:B13,2,0) Adjust search range to your needs HTH -- AP "dalipsinghbisht" <dalipsinghbisht.250i21_1142931612.5005@excelfor um-nospam.com a écrit dans le message de news:dalipsinghbisht.250i21_1142931612.5005@excelf orum-nospam.com... 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 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=524707 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can Vlookup help in that??
That is not working properly cuz some of the date are not coming in that fourmula.. Please help -- dalipsinghbisht ------------------------------------------------------------------------ dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557 View this thread: http://www.excelforum.com/showthread...hreadid=524707 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can Vlookup help in that??
Do you mean SOMe of the dates from Sheet2 appear and SOME don't ?!?!
-- AP "dalipsinghbisht" <dalipsinghbisht.250klm_1142934904.1969@excelfor um-nospam.com a écrit dans le message de news:dalipsinghbisht.250klm_1142934904.1969@excelf orum-nospam.com... That is not working properly cuz some of the date are not coming in that fourmula.. Please help -- dalipsinghbisht ------------------------------------------------------------------------ dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557 View this thread: http://www.excelforum.com/showthread...hreadid=524707 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can Vlookup help in that??
Yes you are right Some dates appears and some don'ts.... please take a look... here is the link for the file.... http://www.geocities.com/dalipsinghbisht/tryit.zip Thanks -- dalipsinghbisht ------------------------------------------------------------------------ dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557 View this thread: http://www.excelforum.com/showthread...hreadid=524707 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can Vlookup help in that??
When i apply a vlookup formula for matching Account no. there is more Account no. but less Date with your Fourmula... -- dalipsinghbisht ------------------------------------------------------------------------ dalipsinghbisht's Profile: http://www.excelforum.com/member.php...o&userid=32557 View this thread: http://www.excelforum.com/showthread...hreadid=524707 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
