Hi
I have 2 worksheet 1 cash flow the second one g journal . In the G job1urnal sheet column B is dates c desc d column debit e column credit and f column amount. the cash flow sheet column b has various items starting from b13 to b19 and row d 2 onwards are dates . what I am trying to do is to check the g journal sheet for items in column e that matches cashflow sheet row b13 to b19 , then tax items in column d of the journal matches b12 of the cash flow and then for the period in the g journal in column b the month that matches the row 2 of the cash flow. eg the row highlighted in red (row 82) shows the date as 12-apr-23 in the b column tax in the d column capital mall in e column and 1000 in the f column. as these match with the row b19 in the cash flow the amount of 1000 is shown in d 19. I tried the sumifs but could not geet the desired result. any suggestions
Shamsu
Bookmarks