Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: X Condition Lookup

  1. #1
    Join Date
    21st August 2008
    Posts
    2

    X Condition Lookup

    Given three criteria (category, name and date) I want to find the specific value within the table or array. Please refer to attachment.

    Thanks in advance
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,784

  3. #3
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: X Condition Lookup

    Hi,

    =SUMPRODUCT(--(B5:B10=C16),INDEX(C5:K10,,MATCH(C15,INDEX(C4:K4,,MATCH(C14,C3:K3,0)):K4,0)+MATCH(C14,C3:K3,0)-1))

    HTH

  4. #4
    Join Date
    21st August 2008
    Posts
    2

    Re: X Condition Lookup

    Thanks Krishnakumar, I have to admit that you are a genious. I spent almost 3 days trying to figure out the answer and I could not do it. Once again thanks.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: X Condition Lookup

    Quote Originally Posted by georgep
    Thanks Krishnakumar,
    You are welcome!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. X Condition Lookup And Variance
    By Pivotman in forum Excel General
    Replies: 2
    Last Post: September 1st, 2008, 10:37
  2. Two Condition Lookup
    By bigtonyicu in forum Excel General
    Replies: 2
    Last Post: June 14th, 2008, 12:11
  3. Double Condition/Criteria Lookup
    By Manolo in forum Excel General
    Replies: 1
    Last Post: May 6th, 2008, 09:25
  4. Return Corresponding Cell To 2 Condition Lookup
    By hotchix in forum Excel General
    Replies: 2
    Last Post: April 25th, 2008, 02:01
  5. Lookup Value If Condition Met
    By zeranity in forum Excel General
    Replies: 11
    Last Post: October 9th, 2007, 00:37

Bookmarks

Posting Permissions

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