Hello guys I am badly stuck on this situation and need help. I have 2 sheets open. Sheet one has 2 columns account number and a disconnect date and sheet 2 has 2 columns account number and payment date. I need to setup a formula so that I can bring dates from sheet 2 into sheet 1, if the date in sheet 2 is within 45 days of the matches date in sheet 1. Now the issue is that I have multiple entries from the same account number and if I use vlookup it only pulls the first date associated with the account number. I need a formula that could go down the line and use all of the dates to match the data associated with one account number.