View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
handyaccountant handyaccountant is offline
external usenet poster
 
Posts: 6
Default 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