In H2 for example, put in a formula like

=if(and(E2="a",F2="b"),A2,"")

then drag fill down the column.

--
regards,
Tom Ogilvy

"CN" wrote in message
...
If I has column E = "a" & col F = "b" then copy cell in col A to col H in
any
row have those value.
Thanks in advance,
CN