Hello,
I have a list of products and those products have different price breaks. If a customer orders over a certain amount they get it cheaper. I need a formula that will look at the price, then look to the price range and return the correct price.
I have attached an example spreadsheet.
Thank You
Last edited by Enigma1985; 07-18-2017 at 06:12 AM.
Please provide a worked example based on one of the stock codes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you for the prompt reply. Please see the updated attached. I would need H3 to be returned from the list, in this example, as it is above the 125,000 threshold.
Try this in H4:
=INDEX($C$2:$C$4824,MATCH(1,(H3>=$B$2:$B$4824)*(H3<$B$3:$B$4825)*($A$2:$A$4824=H2),0))
... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Perfect! Thank You
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks