Return Date Value If Adjacent Field Is Greater Than 0

[torourke17]

I have a table, Column A represents a billing period (11/30/18, 12/31/18, 1/31/19 etc.) and column B represents an amount received for the applicable billing period ($100, 115, 105, etc.).

In a separate cell I want to return a date of the last invoice payment received. So, if the table above shows a value for
(A1)November 30, 2018 (B1)$100
(A2)December 31, 2018 (B2) $115
(A3) January 31, 2019 (B3) $105
(A4) February 28, 2019 (B4) $0
(A5) March 31, 2019 (B5) $0

I'd want the cell B10 to search the table above and tell me that January 31, 2019 was the last billing period I received a payment for. Obviously it has something to do with searching the list and finding a value greater than $0 and pulling that date, but I can't think this through right.

 

[Legacy 436357]

Hi,

I added the amount to the last payment shown here:

Excel Workbook
	A	B	C
1	Date	Payment
2	11/30/2018	$100.00
3	12/31/2018	$115.00
4	1/31/2019	$105.00
5	2/28/2019	$0.00
6	3/31/2019	$0.00
7
8
9		Latest Payment	Amount
10		1/31/2019	$105.00
Sheet1

 

[jtakw]

Hi,

Another option, normally entered:

Book1
	A	B
1	Date	Payment
2	11/30/2018	$100.00
3	12/31/2018	$115.00
4	1/31/2019	$105.00
5	2/28/2019	$0.00
6	3/31/2019	$0.00
7
8
9		Last Payment
10		1/31/2019
Sheet575

Cell Formulas
Range	Formula
B10	=LOOKUP(2,1/(B2:B6>0),A2:A6)