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)) ?
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)) ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks