What rules apply? How do the records on the 1st sheet associate with the
2nd sheet?

Or how do you know which date goes where on the 2nd sheet?


Dennis

"vassilis" wrote in message
...
hello everybody,

I have to work with 2 sheets. In the 1st one my data are arranged as
follows:

Payment Date Type
15/02/2010 XS
15/02/2010 LS
16/02/2010 XS
... ...

and in the 2nd sheet:
Task Activity
XS Activity1
XS Activity2
XS Activity3
LS Activity4
LS Activity5
... ....

and I want to create in a new sheet the following set of data

Payment Date Type Activity
15/02/2010 XS Activity1
15/02/2010 XS Activity2
15/02/2010 XS Activity3
15/02/2010 LS Activity4
15/02/2010 LS Activity5
16/02/2010 XS Activity1
16/02/2010 XS Activity2
16/02/2010 XS Activity3
.... ... ...


I tried several combinations between offset, match, countif but nothing is
working. I would appreciate any help

thank you

vassilis