and function

P

Paul

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?
 
B

Bernard Liengme

Please explain 'Latest Fosia'!G3='DVE open'!F4:F151
Do you mean you want to check if all the cells F4:F151 have the same value
as the single cell G3?
best wishes
 
Top