1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Functions in Excel

Discussion in 'Business Applications' started by cleo123, May 28, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. cleo123

    cleo123 Thread Starter

    Joined:
    May 28, 2010
    Messages:
    1
    Hi. can someone help me simplify this formula?

    =IF(OR(NOT($L4=""),NOT($N4="")),HLOOKUP($H4&"-2",raw_Test1.1!$C$2:$EE$364,MATCH($D4,raw_Test1.1!$B$2:$B$399,0),0),"")
     
  2. Jimmy the Hand

    Jimmy the Hand

    Joined:
    Jul 28, 2006
    Messages:
    1,223
    This seems pretty much the simplest solution. I can think of only two additions.

    1)
    You could define some named ranges, like
    SearchTable = raw_Test1.1!$C$2:$EE$364
    HeaderRow = raw_Test1.1!$B$2:$B$399

    2)
    contract the OR like this
    $L4 & $N4 <> ""

    Result:
    =IF($L4 & $N4 <> "",HLOOKUP($H4&"-2",SearchTable,MATCH($D4,HeaderRow ,0),0),"")

    This formula isn't simpler or faster, but maybe it's easier to read.

    Jimmy
     
  3. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Cleo, welcome to the forum! However, when you have a problem, start your own thread. Jimmy was nice and answered your question (although I would leave your formula as it is), but don't piggyback like that onto someone else's thread in the future.
     
  4. cybertech

    cybertech Retired Moderator

    Joined:
    Apr 16, 2002
    Messages:
    72,116
    Hi, Welcome to TSG!

    I've moved you to a thread of your own so please reply here.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/925939

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice