*=INDEX(A7:A23,MATCH(1,G7:G23,0),1)*

I would recommend that you not include the * in your replies. Some folks
will think those are part of the formula.


--
Biff
Microsoft Excel MVP


"JBeaucaire" wrote in message
...

This should do the trick:

*=INDEX(A7:A23,MATCH(1,G7:G23,0),1)*


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile:
http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45494