| 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 |
| 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 | |||
Threaded Mode
