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