Importing selected rows from one datasheet to another using conditions

Hi All

I'm trying to do something which I thought was simple using indexing and conditions but I cant get it to work.

My second datasheet is supposed to pull only selcted rows of sales opportunity data into a commission sheet based on conditions such as salesman (using Initials) and whether an opportunity was converted into a sale.


I have enclosed an example of the data and the output I would expect to see.

If anyone knows how to do this it would be a big help.

Thanks

PJR