Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Cell and Range Reference (2003)

    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]"," ")

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cell and Range Reference (2003)

    Try this:
    <code>
    =IF(ISNUMBER(SEARCH("Spontaneous",'New Case'!C4)),"[Clinical Only]"," ")</code>

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Cell and Range Reference (2003)

    Hans, you are _never_ going to believe this one....

    I _had_ tried that formula, but since no answer returned, I _assumed_ that my formula was wrong (newbie lack of confidence).

    But, when I pasted your formula, no answer appeared. Then, I 'evaluated the formula' and placed it in the watch window... and the correct answer was appearing... _WHAT_ could be the issue?

    The font color was ... WHITE!
    <img src=/S/scream.gif border=0 alt=scream width=15 height=15>


    Needless to say -> Problem solved.... Thank you!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cell and Range Reference (2003)

    Can happen to anyone... <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •