Thread: interpolation with forecast in a particular interval (HELP)
View Single Post
  #2   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default
D2 should read:
=FORECAST(C2,INDEX(A1:A100,MATCH(MAX
(B1:B100),B1:B100,FALSE)):A100,INDEX(B1:B100,MATCH (MAX
(B1:B100),B1:B100,FALSE)):B100)

HTH,
Bernd
Reply With QuoteReply With Quote