Hello all, I am new to the forums. I feel like I know a bit about Excel, but certainly not *that* intelligent.
I'm attempting to create a spreadsheet that will compile cash register data for me automatically from data that I export from a different program. The exporting issue isn't my problem; I just can't seem to get my "IF AND" formula to work the way I want.
What I have are two worksheets within a single book. The first sheet is called "December Totals" - this is the data that is exported from an external program. I have the numerical data all formatted to the correct category (date, number, etc.).
DecTotals.JPG
The second sheet is called "December Final" - this is the workbook I will print out from the compiled data.
DecFinal.JPG
As you can see, on the "Totals" sheet, there are numerous dates showing cash taken in on certain registers; not all registers have cash transactions each day, so there is no data to export. I'd like to get the "Total Discrepancy" column data to be input into the correct cell, depending on the date and register that had the discrepancy. However, my current formula is not working:
=IF(AND('December Final'!B3='December Totals'!B:B, 'December Final'!C2='December Totals'!A:A), 'December Totals'!H:H, "")
I've tried selecting the entire column (B:B) and individual cells excluding the headers (B2:B17) to no avail.
Hopefully I've explained my issue well enough. I'm turning to the geniuses on this forum to slap me across the face with my error and hopefully get me pointed in the right direction!
Thank you all in advance!!
Bookmarks