Re: Listing data based on a referneced criteria

Dear all especially Peo & Max
Sorry for the delay in responding, just to confirm the formulas posted
worked very well, in fact excellent.

Many many thanks for your time and assistance.
Mick


"Mick" <mickkemp2004-general@xxxxxxxxxxx> wrote in message
news:OQ$loa%23GHHA.420@xxxxxxxxxxxxxxxxxxxxxxx
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 work*** I would have a list of places that met the
criteria.

Any thoughts or has anyone done anything sinilar?

Many thanks
Mick



.

Loading