I am trying to pull 3 cells of data (out of an entire row of data)based on one criteria (>0) from one spreadsheet onto another spreadsheet. I have used a basic IF formula but that results in blank lines when the critera is false. How do I write the formula so when the criteria is true the 3 cells fill in on consecutive rows? Thanks
Bookmarks