Matching 2 fields snd then pasting the line

thanks i will try that aswell. i think I am better with VBa etc. Thanks very much though.

Originally Posted by Marcol

Try this workbook
Data in Cells D7:E7
in F7

=INDEX(Sheet2!$A$2:$F$8,SUMPRODUCT((Sheet2!$C$2:$C$8=$D7)*(Sheet2!$D$2:$D$8=$E7)*ROW(Sheet2!$A$1:$A$7)),COLUMNS($A:A))

Drag Across to K7 then down as required.

[EDIT]
This might be a bit more robust

=INDEX(Sheet2!$A$2:$F$8,SUMPRODUCT(MATCH(TRUE,(Sheet2!$C$2:$C$8&Sheet2!$D$2:$D$8)=($D7&$E7),0)),COLUMNS($A:A))