djl0525
Well-known Member
- Joined
- Dec 11, 2004
- Messages
- 1,240
I have this wonderful formula that filters an importrange for the value in A1. It looks for A1 in column D on the TASKLIST sheet. It works great!
Sometimes column D is left intentionally blank. I would like the filter to include the rows where column D is blank. I want it to look for A1 and blank. I think I need the OR function or the AND function, but I'm not very good at writing nested functions.
Here is my formula.
=FILTER(IMPORTRANGE(J$1, "TASKLIST!A5:H"),IMPORTRANGE(J$1, "TASKLIST!D5:D") =A1 )
Full disclosure: This formula is from a Google Sheets spreadsheet. I don't know if that makes a difference compared to Excel.
Any help will be greatly appreciated.
DJ
Sometimes column D is left intentionally blank. I would like the filter to include the rows where column D is blank. I want it to look for A1 and blank. I think I need the OR function or the AND function, but I'm not very good at writing nested functions.
Here is my formula.
=FILTER(IMPORTRANGE(J$1, "TASKLIST!A5:H"),IMPORTRANGE(J$1, "TASKLIST!D5:D") =A1 )
Full disclosure: This formula is from a Google Sheets spreadsheet. I don't know if that makes a difference compared to Excel.
Any help will be greatly appreciated.
DJ
Last edited by a moderator: