criteria formula will not return data with blank cells

**LRFT** · 02-19-2013, 10:10 AM

I've created a advanced filter with a criteria range. My problem is, the formula evaluates if a given condition is met. If the condition is empty (blank), I want all the any all data retrieved. But it seems the blank condition returns a 0. I thought I could overcome this by stating if the condition is blank, return all using "<>". This isnt working for me either. I tried to return "", this dosen't work either. I also tried "*". No work

Here's the criteria formula I'm using.

=IF(Query!D12="","<>",INDEX(trailerdata,MATCH(TEXT(Query!D12,0),Lookup!B1:B99,0),1))

The data in this column is numeric. Don't bother with the false condition as this is working properly...it's only the true condition that's an issue.

**martindwilson** · 02-19-2013, 12:05 PM

seems a strange criteria,normally there is no need for IF at all just something that returns true/ false
like =OR(D13="",D13>2) as i have no idea what the rest of that function does use true or false
=IF(Query!D12="",true,INDEX(trailerdata,MATCH(TEXT(Query!D12,0),Lookup!B1:B99,0),1))