INDEX, Condition for Array

[ionelz]

I need , INDEX(Array, Row, Col, 0) but ONLY if cell has value

IF (INDEX(Array, Row, Col, 0)<>"",INDEX(Array, Row, Col, 0),"")

Can the Condition be moved to Array ? like IF(Array<>"",INDEX(Array,Row, Col, 0)) ?

[6StringJazzer]

I don't see what you are trying to do in your imaginary formula that is not accomplished by the real formula.

Instead of assuming the solution, it would be better if you could describe what your data looks like and what you are actually trying to do. Then we can propose a solution, which may be totally different than what you thinking is the solution.

[FDibbins]

INDEX generally has 3 arguments, not 4 (unless you are selecting from multiple ranges)
You have a 0 at the end, which is not needed