Using if with incirect and an array doesn't work!

%3CLINGO-SUB%20id%3D%22lingo-sub-2222298%22%20slang%3D%22en-US%22%3EUsing%20if%20with%20incirect%20and%20an%20array%20doesn't%20work!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2222298%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20there%20I%20have%20multiple%20Tables%20in%20one%20sheed%20and%20I%20want%20to%20run%20through%20them%20all%20to%20find%20out%20if%20specific%20culums%20are%20empty.%3C%2FP%3E%3CP%3EI%20tried%20the%20following%3A%3C%2FP%3E%3CP%3E%7B%3DIF((ISEMPTY(INDIRECT(%22Y2020_KW_%22%26amp%3B%7B52.53%7D%26amp%3B%22%5BTitle_1%5D%22))%2BISEMPTY(INDIRECT(%22Y2020_KW_%22%26amp%3B%7B52.53%7D%26amp%3B%22%5BTITLE_2%5D%22)))%26lt%3B%26gt%3B0%3B%22Option%20if%20true%22%3B%22Option%20if%20false%22)%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20it%20isn't%20working%20it%20always%20jumps%20into%20the%20Option%20for%20false%20even%20if%20it%20should%20be%20the%20option%20for%20true.%3C%2FP%3E%3CP%3EI%20already%20tested%3A%3C%2FP%3E%3CP%3E%7B(ISEMPTY(INDIRECT(%22Y2020_KW_%22%26amp%3B%7B52.53%7D%26amp%3B%22%5BTitle_1%5D%22))%2BISEMPTY(INDIRECT(%22Y2020_KW_%22%26amp%3B%7B52.53%7D%26amp%3B%22%5BTITLE_2%5D%22)))%26lt%3B%26gt%3B0%7D%3C%2FP%3E%3CP%3Eand%20it%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20for%20me%20to%20make%20the%20IF%20-%20function%20work%3F%20Thanks%20for%20the%20help%20%3A).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2222298%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2222789%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20if%20with%20incirect%20and%20an%20array%20doesn't%20work!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2222789%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20for%20you%20to%20post%20the%20actual%20spreadsheet%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Hey there I have multiple Tables in one sheed and I want to run through them all to find out if specific culums are empty.

I tried the following:

{=IF((ISEMPTY(INDIRECT("Y2020_KW_"&{52.53}&"[Title_1]"))+ISEMPTY(INDIRECT("Y2020_KW_"&{52.53}&"[TITLE_2]")))<>0;"Option if true";"Option if false")}

 

But it isn't working it always jumps into the Option for false even if it should be the option for true.

I already tested:

{(ISEMPTY(INDIRECT("Y2020_KW_"&{52.53}&"[Title_1]"))+ISEMPTY(INDIRECT("Y2020_KW_"&{52.53}&"[TITLE_2]")))<>0}

and it works.

 

Is there a way for me to make the IF - function work? Thanks for the help :).

3 Replies
Is it possible for you to post the actual spreadsheet?
Thanks for responding but I solved it in another way... but if you’re interested in this specific problem I couldn’t solve, let me know and I fabricate an example file for you.
Not really. I was most likely going to propose another way, but needed to see what you were working with before making any suggestion.