In sheet2!A1

=IF(Sheet1!A110,IF(Sheet1!A1<20,IF(MOD(Sheet1!A1, 2)=0,Sheet1!A1,"")))

"Serge" wrote:

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