Hi
For a formula approach: As HLOOKUP only return ONE match you'll
probably need VBA for this. One way
- download Alan Beban's array functions (http://home.pacbell.net/beban)
They'll include a function called HLOOKUPS (for returning multiple
lookup results)

--
Regards
Frank Kabel
Frankfurt, Germany

"p cooper" schrieb im Newsbeitrag
om...
Ive got some data starting in A1

A B C D E F G H
D N O N O D D D

ie shift workers

={(B1:B8="N")}
gives me an array of true/falses

Id like an array that returns the names of those who match the
criteria
ie {B, D)
I can do it with a series of individual INDEX( MATCH ...) formulae

can i do it with an array formula?
can it be done with a oneliner?