=MATCH("NOT OK";ADDRESS(E2+1;28;0;"Data");0)
The above keeps bringing up an error of #VALUE
I have 2 sheets, "Data" and "Errors". Column 28 of "Data" contains a few "NOT OK". I'm trying to figure out a formula that will return the cell value of the "NOT OK".
The above keeps bringing up an error of #VALUE
I have 2 sheets, "Data" and "Errors". Column 28 of "Data" contains a few "NOT OK". I'm trying to figure out a formula that will return the cell value of the "NOT OK".