Index Match most recent entry

To whom it may concern:

I have a spreadsheet that is populated by an online survey where a survey taker can enter as many times as she desires and can change responses. However, I am only concerned with the most recent response.

For example:

Column A: Column C: Column D: Timestamp User Name Entry 12/10/12 07:37:12 Jon Fish 12/10/12 07:47:12 Larry Fish 12/10/12 07:57:12 Jon Chips

My index-match function for Larry is simple, =index(D:D)Match("Larry",C:C,0) However, if I ask the same thing for Jon, I return nothing my return is not exact. I would like to not only find one result for Jon, but have it based on the most recent time-stamp. *** The time stamp will be in ascending order.

Please advise.

Try this array formula

=INDEX(D:D,MAX(IF(C:C="Jon",ROW(C:C))))

This may help...

=LOOKUP(2,1/($C$1:$C$4=C3),$D$1:$D$4)

Originally Posted by Bob Phillips

Try this array formula

=INDEX(D:D,MAX(IF(C:C="Jon",ROW(C:C))))

Thanks for the help-
Should column a:a be here as the MAX?

No, because I was maxing the row, assuming they would be in date time order.

Originally Posted by Bob Phillips

No, because I was maxing the row, assuming they would be in date time order.

I see that now-- thanks so much!

Originally Posted by aronhubbard

I see that now-- thanks so much!

Hate to bother you again, but I've run into another problem with this specific area.

Let's say there are two questions and they answer one at a time. Such as this:

A	B	C	D
12:01:01	Larry	Fish
12:02:02	Larry		Chicken

I would like the value "fish" to still return when I ask for the MAX time stamp, seeing that it was the most recent answer of that specific question. Is there a function that would allow me to take the most recent response that HAS data?

Please let me know