Thread: Value between 2 values
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kkirank.kmp@gmail.com is offline
external usenet poster
  
Posts: 11
Default Value between 2 values
To you above solution, I need something like this
=INDEX(Sheet1!A:A,MATCH(B1,(B1=Sheet1!B:B) & (B1<=Sheet1!C:C),
1))....I know this does not work, but just wanted to give something
Reply With QuoteReply With Quote