I have an issue with retiring information
I need date to match in both columns I and O as well as vendor Number in columns J & P if they match then I need the Code retrieved in column Q.
I have attached the excel sheet please take a look.
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.