Forum Discussion
Complex validation
I need to return a blank cell (in MERP) if A1 has a name, and if it has a number, to use the name in A1 until a new name is encountered. Currently, the formula in the MERP column is =IF((ISTEXT(A1))...
You may try this...
In F2...
=IF(NOT(ISNUMBER(A2)),"",INDEX(A$2:A2,,MATCH("ZZZ",A$2:A2)))and then copy it down.