Hi all! We're having issues with a spreadsheet at work that I just cannot figure out. Sheet 1 holds information of various invoices. Sheet 2 is meant to pull information from Sheet 1 columns A and B only when a column Z of the same row is marked as 'Recall'. At present our formula reads: =IF(ISNUMBER(SEARCH("Recall",'Sheet 1'!$Z$3:$Z$33)), 'Sheet 1'!$A$3:$A$33, "")). The issue I'm running into is that it's pulling a bunch of blank rows for cells which don't meet my criteria. I realize I specified the blank in my formula but I simply cannot figure out how to specify skipping every row that does not contain "Recall" in column Z. We've tried compound if/then statements as well as query formulas for this. I know it has to be possible but I can't for the life of me figure out a solution. I'm not great with macros, but if that solves it I will try that. I was hoping there would be a formula fix. Any suggestions?
Bookmarks