if column "A" = "clnm4000" and if column "B" = "110" then find all the matches for the first two arguments and copy all results that corresponds in column "C" to "sheet 2" from "A1" I hope that make sence.
So only columns A - C should be copied to Sheet2?

What are the other conditions to be checked? (Some users ask that i show them how to code one condition and they will do the rest, but i would say, atleast let me show you 2-3 conditions, because there could be a shorter way of doing it than just repeating the if condition.)