I'm not sure what you want to do with the information once you get
it....but, maybe one of these will help:

Returns the position of the first "Y" in the list of cells (1 through
10):
=MATCH("Y",A1:A10,0)

Returns the cell address of the first cell containing "Y":
=ADDRESS(MATCH("Y",A1:A10,0),1)

Am I on the right track here?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=380848