Posts by woon liang

    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.


    index_match.xlsx

    Options explicit Error, i am getting this invalid procedure error with the below code. can some experts here tell me why? i declared all my variables already. I'm using excel 2013.