If isna match function???
In Column B I have Sales, Column C Sales Tax and Column D the anticipated
deposit (combination of the two). These columns are broken down for daily
totals in rows 4 thru 34 (1-Jan-08 thru 31-Jan-08).
Further down in the sheet I want to be able to enter into Column D (say row
37) the actual deposit and have cells B37 and C37 populate with the matching
Sales and Sales Tax amount for that deposit
|