Thread: Formula help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBeaucaire[_22_] JBeaucaire[_22_] is offline
external usenet poster
  
Posts: 1
Default Formula help

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

Reply With QuoteReply With Quote