Thread: in range?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default in range?
Hello Bruce,

Array-enter into B1:
=INDEX(E:E,MATCH(1,(A1=$C$1:$C$99)*(A1<=$D$1:$D$9 9),0))
and copy down.

Regards,
Bernd
Reply With QuoteReply With Quote