I have a workbook containing multiple tabs. There is the main tab, Deliveries, and multiple other tabs that are labeled by a number. What I am trying to do is minimize the amount of copy & paste that I'm currently doing, and would like to use a formula that would pull over the data in columns A and G from the deliveries tab, and place them into columns A & B of the tab 6639808, if Column C on the delivery tab is the same as cell C on the tab 6639808. I've tried the IF and VLookup, but something does not seem to be working because I either get an error, or if a date pulls into 6639808, the dates do not match. I'm fairly certain this can be done, but even more certain that I'm going about it the wrong way. I have included a copy of my workbook below.
