Thread: Array formula combined with Lookup
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Kevin Gallagher
 
Posts: n/a
Default Array formula combined with Lookup

Thanks for the help.

I tried this and it worked

=INDEX(List!Z3:Z7202,MATCH(TRUE,List!I3:I7202=MIN(
IF(List!C3:C7202=B4,List!I3:I7202)),0))


--
Kevin Gallagher
------------------------------------------------------------------------
Kevin Gallagher's Profile: http://www.excelforum.com/member.php...fo&userid=7459
View this thread: http://www.excelforum.com/showthread...hreadid=518104

Reply With QuoteReply With Quote