Assuming your data in A1:F5

NY MO IL NJ KS
Jim x x x
Joe x x x x
Amy x x x
Jane x x x x

Criteria in G1

In H1:
=LOOKUP("zzzz",CHOOSE({1,2},"",INDEX($A$2:$A$5,SMA LL(IF(($B$1:$F$1=$G$1)*($B$2:$F$5="x"),ROW(INDIREC T("1:"&ROWS($A$2:$A$5)))),ROWS($1:1)))))

ctrl+shift+enter, not just enter
copy down as far as needed



"C-Breeze" wrote:

We use Excel for our memebrship data, on our zip code entires for NJ and Y
which have a leading zero we get a blank. On last number in CC entry we only
are able to display, 0, 1, or 2
-- How do we over come these issue?
C-Ya

GC