=INDEX(B2:B200,MATCH(1,(E2:E200="Johnson")*(I2:I20 0="Batch
1")*(S2:S200="No"),0))


entered with ctrl + shift & enter

replace the name, batch and yes/no with cells like E2:E200="Johnson and
instead use E2:E200=D1
that way you don't have to edit the formula when you change the criteria


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)



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