hi there
hope you are doing good.
Please advise how to lookup within an interval value and match the criteria.
I highly appreciate if you can advise me with formula and using vba.
please find the attached for your reference.
Thanks in advance.
hi there
hope you are doing good.
Please advise how to lookup within an interval value and match the criteria.
I highly appreciate if you can advise me with formula and using vba.
please find the attached for your reference.
Thanks in advance.
Change your formula to:
The formula now looks for the " - " to determine where to look for the upper end of the interval.=SUMPRODUCT(--(C3>=LEFT($F$14:$F$31,FIND(" ",$F$14:$F$31)-1)*1)*--(C3<=MID($F$14:$F$31,FIND(" - ",$F$14:$F$31)+ 3,10)*1)*--(D3=$G$14:$G$31)*($H$14:$H$31))
Your first "should be" is incorrect. The formula was calculating correctly for the combination supplied.
hi mbarron
It's work. thank you and highly appreciated it.
Have a nice day!