Lookup

[empee]

Hi,

I'm having two collum's in collum F there's a list of dynamic date's.
In collum G there's a number between 0 and 2. like this:

Collum F Collum G
2004-01-01 00:00:00 0
2004-01-13 11:28:42 1
2004-01-13 11:28:43 2
2004-01-13 11:38:27 1
2004-01-13 11:38:29 0
2004-01-14 00:00:00 0

In collum H i want excel to display the date which has a value of 2 in
collum G. So in this case it would be like this:

Collum H
2004-01-13 11:28:43

I've tried doing it with the lookup function:
=LOOKUP(I3;G2:INDEX(G:G;I4);F2:INDEX(F:F;I4))

I3 = the cell with the lookup value, in this case 2
I4 = the cell which counts the number of date's for the end of the table

This function works ok if there are only a few rows, but if there are more
rows in the collum it will just give the last day in the collum.
It's a long question but i hope somebody could help me out here!!!
Thanx!

 

[Krishnakumar]

Try,

=INDEX(F1:F6,MATCH(H1,G1:G6,0))

Kris

 

[empee]

thanx it works great, could you also tell me what it should be if there were more date's with a value of 2?

Thanx!!!
MP

 

[Krishnakumar]

Hi,

Click here.

Something similar to yours.

Kris