I created the following formula to check for conditional data – on the same worksheet. Now, I want to be able to make the same conditional statement (refer to the same cell), but from a different worksheet. Every time I try to add a worksheet or range reference, I seem to get an error.
The name of the worksheet is “New Case”. If it helps, the cell is also in a range titled “NEWCASE”.
ORIGINAL FORMULA: =IF(ISNUMBER(SEARCH(“Spontaneous”,C4)),”[Clinical Only]”,” “)
FORMULA FROM ‘other’ worksheet: ???
I tried the following, but it of course has returned an error:=IF(ISNUMBER(SEARCH(“Spontaneous”,NEWCASE,C4)),”[Clinical Only]”,” “)
