Hello!
I have tried to work out the formula and find the answer to this in the forum, it's probably been resolved in a different threat but I can't find it so I hope someone can help me with the answer or the link of the treat where this has been solved.
I have a table where I have a code in the horizontal column and quantity in the vertical and I need the index match to bring the value also when the quantity is between a range.
I.e, I have code ES0697 with quantity 35K, this price is between the 30&50K so the formula should bring the price for 30K. If the quantity is 53K should bring zero as there is no price in that range.
Thanks!!
Bookmarks