+ Reply to Thread
Results 1 to 2 of 2

Multivariable bottom-to-top LOOKUP

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Multivariable bottom-to-top LOOKUP

    In the worksheet attached, I want a formula to calculate the difference between ALARM time & RESET time for a given tag number. Every time a RESET event occurs (Column B) I want to go back to the last time that tag showed a ALARM event and display the date/time in Column C.

    If I use formula =LOOKUP(2,1/(A2:A100=A16),C2:C100) in cell D16 it will locate an incorrect tag event - the one that says FORCE. Can this search be done using 2 criteria? I would want not only to search for A16 in Column A but also look for the word "ALARM" in Column B and then return the date/time value from Column C. Cell D16 should retrieve the value from cell C12 (as shown typed in manually) since that was the last time Gas1 had a ALARM event. I tried to nest a AND statement in it, =LOOKUP(2,1/AND(A2:A100=A16,B2:B100="ALARM"),C2:C100), but it didn't work.
    Attached Files Attached Files
    Last edited by zoefrannie; 08-16-2013 at 12:46 PM.

  2. #2
    Forum Expert
    Join Date
    The Netherlands
    MS-Off Ver
    Office 365

    Re: Multivariable bottom-to-top LOOKUP

    Read the topic below for better and quicker help on your question.

    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match/Index/Lookup - Searching From Bottom to Top (A reverse lookup maybe)
    By Neutralizer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2013, 03:55 AM
  2. multivariable graph
    By Omoniatis2 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-21-2013, 12:01 AM
  3. Reverse LOOKUP to find the Second matching value from the bottom
    By Nomad33 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-19-2013, 10:41 PM
  4. Replies: 1
    Last Post: 04-09-2006, 04:30 PM
  5. Lookup when values located in a row across bottom of table of data
    By Mark444 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2006, 03:39 PM


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1