I have 8000 line file that I am trying to identify a particular discount amount against another file of about 3000 lines. I have to match an item # plus a start and end date with the other file within a date range and bring back a discount/dollar amount. The table will look like this.
File...