Not sure whether to use Vlookup or IF AND THEN or combo???

Thanks in advance for all the great help I've received here.

Need help again. As always..... there are usually 6 different ways to accomplish the same goal in excel YEAH EXCEL!!!!

I have a sheet of hundreds of transactions as line items and I need it all be changed on another sheet to be column items and totaled at the end. I've attached a sample book

I've figured out the way to return the dollar value in column 7 if the date is found in SHEET1 by using the VLOOKUP

But now I'm trying to figure out how to add another logic test to the formula.

I know its simple but it's eluding me. WHAT am I missing here?

Thank you both. I was somehow afraid this would get into Formulas 102!!

Yes! I am still using 2010. Haven't been compelled nor forced to change yet.

So I took the formula you provided Glenn, and made a couple of modifications. It failed at row 100. I have hundreds of rows. Just replaced it with like 10000!
I copied it down and across and everything worked great!!
Except... when I inserted another column to give a value for when Late Charges were accessed. (Didn't see that at first. It didn't happen till about row 200).
So I simply inserted another column on the results page as column E and copied the formula over and then down. Never picked up the late charges

Ahhh. just figured it out. All the charges are posted on the 1st, as is the date on the results page.
The late charges don't post till the 9th. So it isn't picking up those charges.

Its only 15 out of hundreds. I'll copy them manually! LOL

Thanks again. Love working with you all. It humbles me every time.