FILTER and IMPORTRANGE for Google Sheets

[djl0525]

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

 

[veyselemre]

It has not been tried.

= QUERY ( IMPORTRANGE ( J1 , "TASKLIST!A5:H" ) , "SELECT * WHERE Col4='" & A1 & "' OR Col4=''" )