Index Match with proration of upper and lower values.

  • Hi experts!

    i am trying to use match to get upper and lower values of the horizontal and vertical data but i am only able to get the lower data and not the upper data.

    The purpose of getting upper and lower data is to prorate them and get the pro-rated value from 4 value. (upper & lower value of x-axis AND upper & lower value of y-axis)

    having the 4 values and prorate accordingly and now it seems like i am able to only get one value instead of all the 4 value to prorate.

    Attached is the excel sheet for reference.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!