Thread: Price with different break points
View Single Post
 
Old 12-06-2017, 01:14 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Try:

=IF(A3="","",LOOKUP(2,1/(($H$2:$L$2="Breakpoint")*(INDEX($H$3:$L$5,MATCH($ B3,$F$3:$F$5,0),0)<=$A3)),INDEX($I$3:$M$5,MATCH($B 3,$F$3:$F$5,0),0)))
Reply With Quote