and function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting elements of a string cell 11
Over time hours 5
Summing across multiple worksheets in excel 2007 3
CountIf Formula 1
Make Function ignore 0 and error values 3
Counting formula 1
How can I reference a cell within a formula 3
Look up query 1

Back
Top