Check all sheets (except two) for value and return a true/false

[mr_mango81]

Hello guys,
I've got a workbook that will have a sheet called "menu", a sheet called "QEHS Docs" and then many identical sheets which represent projects e.g "P189", "P190", "P191"....etc. (the number and names of these sheets will vary). I am after a formula (preferably not VBA, but happy to play with it if that's the only way) that will check the same cell in all the project sheets (e.g. F4) but NOT the sheets "menu" & "QEHS Docs" and return a true/false if the any of the cells contain any values.

E.G. =IF(Sheets(All except "menu" & "QEHS Docs").Range("F4").value <>"",True,False)

If anyone can help, it would be greatly appreciated.

[Miroslav R.]

Hi there,

You can use formula with INDIRECT, but that requires that You have all relevant sheet names on one (summary) sheet.
example:
sheet name is in B3 = "P189"

Please Login or Register  to view this content.

This formula returns value form range F4.