Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Location
    Calgary, Alberta, Canada
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    LOOKUP formula (Excel)

    I

  2. #2
    New Lounger
    Join Date
    Sep 2005
    Location
    Calgary, Alberta, Canada
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LOOKUP formula (Excel)

    Something to add in the conditions section (cell array D8:K21) is basically a matrix. if there is a 1 anywhere in this matrix it corresponds to the system on the same row and the condition labled above.

  3. #3
    2 Star Lounger
    Join Date
    May 2005
    Location
    Vancouver, Br. Columbia
    Posts
    223
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LOOKUP formula (Excel)

    I tried understanding the formula but figured this might be easier, does this attachment work>

  4. #4
    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: LOOKUP formula (Excel)

    Not sure exactly what you are after but here is a try
    1) in B10:
    =INDEX($D$1:$M$1,MATCH(A10,$D$2:$M$2,0))
    Hlookup expects the lookup value in the top row of the range
    [You could reverse rows 1 and 2 and use:
    =HLOOKUP(A10,$D$1:$M$2,2,0) in D10]

    2) not clear at all at what you want. How is this:
    =IF(OR(AND(D8<$P$2,$P$2<D9,D10=1),AND(E8<$P$2,$P$2 <E9,E10=1),AND(F8<$P$2,$P$2<F9,F10=1),AND(G8<$P$2, $P$2<G9,G10=1),AND(I9=$P$4,I10=1)),1,"")

    Steve

  5. #5
    New Lounger
    Join Date
    Sep 2005
    Location
    Calgary, Alberta, Canada
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LOOKUP formula (Excel)

    Under system stage I have used this formula which doesent work
    =IF(OR(B19<$B$2,$B$2<C19,$B$4=D19,$B$3=E19),VLOOKU P(A19,$A$2:$B$15,2,FALSE)

  6. #6
    2 Star Lounger
    Join Date
    May 2005
    Location
    Vancouver, Br. Columbia
    Posts
    223
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LOOKUP formula (Excel)

    Try this
    =IF(AND(B21<$B$2,$B$2<C21,$B$4=D21,$B$3=E21),INDEX ($A$6:$A$15,MATCH(A21,$B$6:$B$15,0)),"")
    and drag it down

  7. #7
    New Lounger
    Join Date
    Sep 2005
    Location
    Calgary, Alberta, Canada
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LOOKUP formula (Excel)

    Yes sorry Patrick and Steve and Thanks for your Time. I have attached a better example of what I am trying to achieve. I have added comments to the worksheet to describe it.

    Hopefully this is clearer.

    Thank You

Posting Permissions

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