Cross reference with 2 Variables

  • Re: Cross reference with 2 Variables


    If you use a "Helper" column to combine the date and vendor number, then it is a straight forward index/match formula. See attached. The help column can be hidden.


    Regards
    Ger

    Files

    • Helper.xlsx

      (26.12 kB, downloaded 27 times, last: )

    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    [SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...


    The BEST Lookup function of all time


    Dynamic Named Ranges are your bestest friend[/SIZE]
    _______________________________________________