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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Paul" wrote in message
...
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?