I need a formula in sheet 2 that will copy or equal a cell in sheet 1 but
only if matches 3 (and or) 4 criterias.

Your help is much appreciated.
Many thanks
Serge