0
I have a sheet of transactions categorized as either income or expenses. I would like to populate expenses which are more than a certain value, say, more than $5,000, as a list in another sheet. I tried various combinations of IF, SUMIFS, VLOOKUP, INDEX, MATCH but just cant get it right. Any ideas???
1The question is about writing the result in another sheet – yass – 2017-07-02T20:44:33.327
Understood. You can have the lookup formula - VLOOKUP, INDEX/MATCH, whatever - in the second sheet to pull values from the 1st sheet. I am assuming that in the second sheet, the user will also want a description of the expense, not just the amount. After all values are pulled into the second sheet, the user can manage the data in the column of numbers to eliminate zero values. I'm not certain, but if the user wants to only populate the list with the non-zero values, some VBA may be required to store the non-zero values, then print them. – Bruce Kaufmann – 2017-07-03T02:32:01.247