Return value in column "A" of a row containing certain value in column "I"

[dprows]

I have a spreadsheet with dates in column A. I am trying to find a way to return that date of the last occurance of a specific value in column I.

 

[Scott Huish]

Hi, welcome to the board!

You didn't say what you were looking for in column I, so in this example we are returning the date for the last occurrence of N:

=INDEX(A1:A20,MAX(IF(I1:I20="N",ROW(I1:I20)-ROW(I1)+1)))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.
Format as date.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	8/27/1977								J			3/15/1996
2	8/16/1970								G
3	7/12/1990								L
4	2/21/2002								R
5	1/15/1984								U
6	4/25/1995								B
7	1/19/1973								X
8	2/18/2000								O
9	12/23/1984								U
10	3/8/1987								K
11	5/9/1977								S
12	3/19/2006								Y
13	12/30/1976								L
14	7/22/2002								A
15	6/4/2009								O
16	5/9/1993								N
17	8/22/1996								J
18	3/15/1996								N
19	4/30/1985								Y
20	12/9/1981								T
Sheet1

 

[T. Valko]

Here's another one...

Return the date from column A that corresponds to the *last* instance of "x" in column I.

=LOOKUP(2,1/(I2:I20="x"),A2:A20)

Format as Date

 

[dprows]

Here's another one...

Return the date from column A that corresponds to the *last* instance of "x" in column I.

=LOOKUP(2,1/(I2:I20="x"),A2:A20)

Format as Date

I ended up using this one. Thank you both for your help.