I'm trying to compare 2 worksheets into a third using this basic formula...
=IF('Latest Fosia'!G3='DVE open'!F4:F151, "On Both", "On Fosias" ). I need to
check in the reverse so =IF('DVE open'!F117='Latest Fosia'!G3:G500, "On
Both", "On DVE"). how can I combine these 2 into one formula?