| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help 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..... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help data match up
Sheet 1
E1: =SUMPRODUCT((ISNUMBER(MATCH(Sheet2!A1:A6,A1:A5,0)) )*(ISNUMBER(MATCH(Sheet2!B1:B6,B1:B5,0)))*(ISNUMBE R(MATCH(Sheet2!C1:C6,C1:C5,0)))) adjust your range to suit Note: you can not use a whole column prior to XL-2007 "K****ij" wrote: 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..... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help data match up
Thank You for the same..... Really Thanks....
"Teethless mama" wrote: Sheet 1 E1: =SUMPRODUCT((ISNUMBER(MATCH(Sheet2!A1:A6,A1:A5,0)) )*(ISNUMBER(MATCH(Sheet2!B1:B6,B1:B5,0)))*(ISNUMBE R(MATCH(Sheet2!C1:C6,C1:C5,0)))) adjust your range to suit Note: you can not use a whole column prior to XL-2007 "K****ij" wrote: 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..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cross match data in Col A v/s Col B and display match in Col 3 | Excel Discussion (Misc queries) | |||
| Formula to match data | Excel Discussion (Misc queries) | |||
| Formula to match 7 columns of non adjacent data | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
| formula to extract specific data if match occurs | Excel Worksheet Functions | |||
Hybrid Mode
