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.



    • 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]