make sure you press ctrl+shift+enter (not just enter) after edit the formula


"Mick" wrote:

I am trying to identify what function(s) to use to give me the data listed
in column B if column E, I & S meets my criteria.
e.g if column E = "NAME" and column I = "Batch 1" and column S = "No", then
return the entry in column B.

so on a different worksheet I would have a list of places that met the
criteria.

Any thoughts or has anyone done anything sinilar?

Many thanks
Mick