Hi Experts, I am not sure if my title explains, basically, i am using the index and match to find rates for my chart, however unable to get around using index and match to find with range of numbers.



for example:
i have 4 groupings and a range of numbers <1000, <1500, <2000 etc

and under them are rates of how much it will be.

if using index and match i am able to do specific numbers but i am not about to put in it range...
i would like to be able to change the group and amount(of any range) and able to produce the results.


Thank you very much if you are about to help point me or guide me to solve the problems.

Best regards

Attached Files

help 1.xlsx (11.6 KB, 10 views)