Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2007
    Location
    California, USA
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Help (2003 Service pak2)

    I am trying to modify the LOOKUP formula in cell C7 to show no value untill a value is reflected in cell B7. Any Suggestions?

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

    Re: Formula Help (2003 Service pak2)

    What do you mean by "a value is reflected in cell B7"? I don't see any mirrors.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula Help (2003 Service pak2)

    How about:
    =IF(B7=0,"",IF(ISERROR(LOOKUP(B7,T4:T64,U4:U64)), "", LOOKUP(B7,T4:T64,U4:U64*H13)))

    Steve

  4. #4
    Star Lounger
    Join Date
    May 2007
    Location
    California, USA
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (2003 Service pak2)

    Hi Hans, Yeah, poor choice of words-- no mirrors <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20> . I should have said no positive value in C6. Steve figured out what I meant to say and provided a solution. Thanks to you both!

  5. #5
    Star Lounger
    Join Date
    May 2007
    Location
    California, USA
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (2003 Service pak2)

    Thanks Steve, works perfect!

Posting Permissions

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