Posts by mkohaji

    Hello experts,


    I am trying to find a way to use lookup or any other formula to return the results of the first value bottom up.
    Ex.
    My data is an org codes. So, if the object code is (3), I want excel to give me the org code of the first (2) starting from the selected cell going up.


    1 120000
    2 120001
    3 120002
    3 120003
    3 120004
    2 120005
    3 120006
    3 120007


    So, 3 120006 should return the value of 2 120005 not 2 120001.



    I hope my explanation is clear enough.


    Any thoughts?!!


    I've tried lookup, vlookup, index, match, nothing worked so far or I night not used it right !