# Finding row on matrix matching 3 criteria and get a result (hour)

1. ## Finding row on matrix matching 3 criteria and get a result (hour)

Hello,

The matrix:
Col A Col B Col C
2012-11-08 07:26:16 Check-In John
2012-11-08 13:23:58 Check-Out John
2012-11-08 13:24:01 Check-In John
2012-09-27 07:34:13 Check-In Marie
2012-09-27 17:35:31 Check-Out Marie
2012-09-28 07:10:16 Check-In Marie
2012-09-28 17:34:40 Check-Out Marie

The goal:
Since i have a given:
1. Name(which exists in column C)
2. Date (which exists in column A - formated has (AAAA-MM-SS HH:MM:SS)
3. Event (which exists in column B)
4. Hour*

I want to know the nearest hour that matches all criterias.

In the example on top, if i give:
John, 2012-11-08, Check-In, 14:00:00
I want the result: 13:24:01

If, for example, the date doesn't exist, the result could be a simple error message.

Anyone can help me?

2. ## Re: Finding row on matrix matching 3 criteria and get a result (hour)

Welcome to the forum!
Attached is an example workbook based on the criteria you described.
In cells F2:F5 is where the search criteria gets entered.
In cell F7 is this formula to get the result:
``Please Login or Register  to view this content.``

Does that work for you?

3. ## Re: Finding row on matrix matching 3 criteria and get a result (hour)

Hi tigeravatar,

It seems to work like a charm!
If I find any issue, I will back to you.

Thank you very much!
Regards

4. ## Re: Finding row on matrix matching 3 criteria and get a result (hour)

You're very welcome

New quick method:

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

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