| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Match up
Hi
I have a dat of around 2500 line in 2 sheets of a workbook(in Excel 2003), I need to match up these data with eachother. the data in column A(sheet 1) should match with A(Sheet 2) than it should go and find the next condition that it should match column B and than same for column C. I tried Vlook up, but couldn't succeed with it. The data seems as below... sheet 1 347 1-Dec-2004 4,000 347 1-Dec-2004 3,150 347 1-Dec-2004 5,000 347 1-Dec-2004 3,000 347 1-Dec-2004 11,000 sheet 2 347 1/12/2004 4,000 347 1/12/2004 5,000 347 1/12/2004 3,000 347 1/12/2004 10,000 347 1/12/2004 1,150 347 2/12/2004 5,000 So now it sould give me match for the 3 numbers..... Can any one help me for this as it could ease up my work a lot..... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match data, count data and report to diffrent sheet. | Excel Discussion (Misc queries) | |||
| Cross match data in Col A v/s Col B and display match in Col 3 | Excel Discussion (Misc queries) | |||
| Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
