Home

Display array from another sheet with criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-533782%22%20slang%3D%22en-US%22%3EDisplay%20array%20from%20another%20sheet%20with%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533782%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20made%20an%20excel%20sheet%2C%20where%20i'm%20trying%20to%20insert%20an%20array%20that%20i've%20made%20in%20another%20sheet.%20I'm%20trying%20to%20make%20it%20so%2C%20if%20a%20cell%20have%20the%20value%20%22YES%22%20it%20will%20show%20the%20array%2C%20and%20if%20the%20cell%20says%20%22NO%22%20it%20wont%20show%20the%20array.%20Is%20this%20even%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-533782%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
hedelaj
Occasional Visitor

Hi!

 

I've made an excel sheet, where i'm trying to insert an array that i've made in another sheet. I'm trying to make it so, if a cell have the value "YES" it will show the array, and if the cell says "NO" it wont show the array. Is this even possible?