I am using the query function with 3 different ranges within 1 formula, Where i want to Select a column if Column X = to a 'Name'.
The problem i am facing currently is that the first 2 Ranges are give me back 2 Null values since it cannot find the name and the 3rd range contains the name.
I am using the following formula:
=iferror( { Query(Range,"select B Where C = 'Name'",-1); Query(Range, "select E WHERE F = 'Name'", -1); Query(range, "select H WHERE I = 'name'",-1) } )
I am getting the following result:
Blank
Blank
Name
Is there a way i can force the formula not spit out a blank if it doesn't find the name or value?
The problem i am facing currently is that the first 2 Ranges are give me back 2 Null values since it cannot find the name and the 3rd range contains the name.
I am using the following formula:
=iferror( { Query(Range,"select B Where C = 'Name'",-1); Query(Range, "select E WHERE F = 'Name'", -1); Query(range, "select H WHERE I = 'name'",-1) } )
I am getting the following result:
Blank
Blank
Name
Is there a way i can force the formula not spit out a blank if it doesn't find the name or value?
