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.....