Forum Discussion
How can I LOOKUP a Value with Conditions Bound by a Range
I have Sheet A - Price List that lists multiple prices (Column D) per Product ID depending on the Quantity that is purchased (range from and to in Columns B and C). In Sheet B - Lookup Price Based o...
=INDEX($D$3:$D$22,MATCH(1,($A$3:$A$22=G3)*($B$3:$B$22<=H3)*($C$3:$C$22>=H3),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
=INDEX($D$3:$D$22,MATCH(1,($A$3:$A$22=G3)*($B$3:$B$22<=H3)*($C$3:$C$22>=H3),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
Excellent, thank you so much for the solution! Much appreciated
